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