Highlight cells

  • Thread starter Thread starter Goyo
  • Start date Start date
G

Goyo

I am trying to highlight a cell if it is empty. However, the cell in
question is pulling data from another page in the worksheet, so the cell is
not empty because it contains the address of the referenced cell. I have
tried conditional formating and "IF" and couldn't get any of them to work.
Any suggestions?
 
A1 cell formula =IF(B1="","",B1)

A1 Conditional Formatting>Formula: =A1=""


Gord Dibben MS Excel MVP
 
Back
Top