Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting a Linked Cell
I have a cell on sheet 2 that is linked to a cell on sheet 1 of the same work
book. When the cell is empty on sheet 2 (i.e. no entry on the link in sheet 1), I would like the cell on sheet two not to have a fill color. If the link comes back with values I would like to have the fill be a certain color. Reading through several posts I have tried using conditional formats as follows with no luck: 1. cell value is not equal to ="" 2. Also tried many isblank, is not blank Thanks, Danny |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Applying conditional formatting to cell based on another cell's in | Excel Discussion (Misc queries) | |||
Conditional Formatting to Test Value in Cell | Excel Worksheet Functions | |||
Conditional Formatting For A Cell Other Than The One With The Form | Excel Worksheet Functions | |||
Transfer Cell Formatting for linked cells | Excel Discussion (Misc queries) | |||
enhanced conditional formatting | Excel Discussion (Misc queries) |