conditional formatting

**dnm** · 05-20-2010, 01:22 PM

Hello,
I am trying to use conditional formatting for the following:
If Column C is empty and Column I has a value in it
- in this case a due date-
I want the entire row highlighted.

Column C is the column where a project is deemed as closed or not. If it is closed it will have a date (and not be blank). If it is open, it remains blank.
Column I is where the due date is entered. I figured these two conditions would suffice to a) give me the highlights I want and B)not have the whole spreadsheet highlighted.

I can't seem to figure it out. Any help you could offer would be most appreciated.
thanks
dm

**NBVC** · 05-20-2010, 01:24 PM

select the row(s) and go to Format|Conditional Formatting.

Select Formula Is and then enter:

=AND($C2="",Isnumber($I2))

where C2 and I2 are in the top most row of your selection.

Then click Format and choose from the Pattern tab.