Hi Folks,

can you tell me how to use conditional formatting to highlight cells in Column A only if the adjacent cell in Column B is blank please?

Both cells contain dates and Column A also has conditional formatting applied to change the font colour if the date is less than 14 days from now.

both columns are dates for documents. Column A is a due date Column B is an actual submission date. I don't want the worksheet to highlight a document as due if at's already been submitted.

Hope that makes sense?


Thanks in advance for any assistance.