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
Bookmarks