Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I make the fill color of a cell on one sheet follow the co.
|
#2
|
|||
|
|||
Hi
please post back with the question in the message body rather than the subject line ... also let us know what version of excel you're using as i think the functionality you're after changes in different versions. Cheers JulieD "SteelerfanDan" wrote in message ... |
#3
|
|||
|
|||
You can't use a worksheet function to link one cell's colour to
another's cell's colour. You might be able to use conditional formatting, to colour the cells based on their content. There are instructions in Excel's Help, and he http://www.contextures.com/xlCondFormat01.html For something more complex, you could use programming to colour the dependent cell. SteelerfanDan wrote: -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FORMULA TO MAKE CELL COLOR CONTINGENT | Excel Discussion (Misc queries) | |||
How do I fill row colors based on cell value? | Excel Discussion (Misc queries) | |||
How can I make the bar that shows the content of the cell visible. | Excel Discussion (Misc queries) | |||
make a cell empty based on condition | Charts and Charting in Excel | |||
how do I make a cell flash | Excel Discussion (Misc queries) |