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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting a Linked Cell
Your attepts won't work because the dependent cell is never empty or
blank (it has a formula in it). Since the dependent cell is 0 if there is no value in original cell, CF formula could be cell value not equal to = 0 format blue ed |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting a Linked Cell
Ed,
Thanks for the responding and in my case your tip did the trick! Thanks! Danny " wrote: Your attepts won't work because the dependent cell is never empty or blank (it has a formula in it). Since the dependent cell is 0 if there is no value in original cell, CF formula could be cell value not equal to = 0 format blue ed |
Reply |
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) |