Thread: Conditional Formatting Question

HI,

I am applying conditional formatting which is working fine. I have the cell turn yellow for dates coming up in the next 7 days and red for dates past due. But I have another column to the left of the date column that I mark as open or closed. I only want the conditional formatting to be applied if the cell to the left contains the text "Open". If it contains the text "closed" no conditional formatting should be applied. I'm basically tracking open action items that are due. Once they have been completed, I still want to show the dates, but no longer need them highlighted.

Thanks
David

You have to use a formula like this one:

=AND(C1="Open";D1<NOW())

You also want 2 conditions for the conditional formating.
See attached file.
Regards
Pierre

Thank you so much for your help on this. This solution worked perfectly.