Evaluting a Cell as a Blank and applying Conditional Format

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

I have a column of cells formatted as dates "23-Mar-03".
Sometime a date is missing becuase that action has not
occur as of yet. The cell in this case is blank, I want to
conditional format the cell so that when it is blank the
cell pattern (cell color) changes to blue.
 
I tried that formula but to no avail. The background is
still white. I have them formatted as date cell could
thank cause a problem.
 
Formatting will not cause a problem. However, if the cell isn't
really blank (i.e., has formulas or space characters - " " - in it,
IsBlank will return FALSE)

You can use

Formula is =LEN(TRIM(A1))=0

instead.

For In article <[email protected]>,
 
Back
Top