asked on

Entering text and format into non connected cells

Hi, I have an excel workbook where I want to be able to enter information into one cell on a spreadsheet, and it will be repeated in another cell on a different spreadsheet. The spreadsheets are laid out differently. I already have used ='HDP map - control doc'!M12 to so that text is automatically updated. However there is a range of cells which I have put blocks of colors into them, to show which years activity will take place. In this case when I use the same method, all I get it a zero in that cell.

Is there a way of ensuring that everything will be shown in cell B, including formatting when I type into a cell A?

Thanks

ASKER CERTIFIED SOLUTION

Rob Henson

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Peter Alflat

ASKER

Hi Rob, I just realised you have answered my question, once the conditional formatting is in place, i just use the = (cell reference). It would just mean entering say 1,2 or 3 into the first cell to 'trigger' red amber and green, and this will be repeated in the second cell. Thanks for your help. :-)

Frank Helk

No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I have recommended this question be closed as follows:

Accept: Rob Henson (https:#a41840366)

If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.

frankhelk
Experts-Exchange Cleanup Volunteer