Evaluting a Cell as a Blank and applying Conditional Format

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.
 
B

Bill

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.
 
J

J.E. McGimpsey

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 <136101c3888b$caa6b320$a301280a@phx.gbl>,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top