Conditional Formatting a Linked Cell

D

Danny

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
 
E

edcosoft

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
 
Top