Conditional formating based on blank cell

K

Kimti

I have data in the few cells in the row. I would like to format different
color based on one cell in the row, for example:
A B C D E F
12 12 56 43 87 Oct 12, 2009
76 98 56 34 21

I want to highlight row 2 as F2 is blank (there is no date).

Thanks in advance for your help.
Kimti
 
M

Max

As real dates are numbers, you could try this ..
Select the entire sheet, apply CF using Formula Is:
=AND(ISNUMBER($F1),$F1<>"")
Format to taste > OK out
Any good? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
 
K

Kimti

Thanks for your help, it did not work the way I would like to see. I want to
see only one row to be conditional formated based on the date not being in
one cell for that row. whole idea is that that cell is showing if the task is
complete. If date is not their I want to see different color so it stands out
from the sheet.

Thanks,
Kimti
 
M

Max

Sorry, I had it the other way around earlier
Same steps, but use this as the CF formula:
=NOT(ISNUMBER($F1))

You could pre-fill the entire sheet with a fill color of your choice as the
"untriggered" background
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
 

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