Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I link a color format from 1 cell to a cell in another tab?
I am adding a background color (Red, Yellow or Green) to a cell to indicate
progress attained. I would like a different cell in a 2nd tab of the workbook to automatically be updated with the color that was put into the 1st cell. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I link a color format from 1 cell to a cell in another tab?
Hi Greg,
Can only be done in a macro and very inefficiently, because it would have to be a volatile macro. If you are willing to do your own calculate (F9) or trigger a macro when the sheet is brought up, or you double click from a sheet then you can use non volatile macros. In other words relying on color alone is not a good idea and there are many forms of color blindness. You can probably get what you want through Conditional Formatting if you can use a formula to determine what color you want. Conditional Formatting must not refer to another sheet, so you might be able to use a helper column. For the macro solution see Functions For Cell Colors http://www.cpearson.com/excel/colors.htm Many answers to questions on color can be found at http://www.mvps.org/dmcritchie/excel/colors.htm and many answers to Conditional Formatting can be found at http://www.mvps.org/dmcritchie/excel/condfmt.htm --- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Greg @ Campbell Soup" <Greg @ Campbell wrote in message ... I am adding a background color (Red, Yellow or Green) to a cell to indicate progress attained. I would like a different cell in a 2nd tab of the workbook to automatically be updated with the color that was put into the 1st cell. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Link to Cell Not Updating | Excel Worksheet Functions | |||
hyperlink - link one cell to another in a worksheet. how? | Excel Worksheet Functions | |||
Replace part of link address in a cell with a value(date) from ano | Excel Discussion (Misc queries) |