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

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

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