Conditional formatting formula

[shepherdc2814]

Hello,

In the attached spreadsheet, I want to highlight the cell in column B when the following conditions are met. If column B contains "In Progress" or "Not Started" AND column C contains any date, then format the corresponding cell in column B.

Thanks everyone for your help!

[p24leclerc]

try this formula in the conditional formatting window:

Please Login or Register  to view this content.

You can change the range this condition is applied to according to your data.

[shepherdc2814]

That formula worked, thank you!