Conditional formatting with formula (multiple criteria)

L

lzrdlvr

I have dates in one column to show the due date of an action item. In the
"status" column to the right, I have whether or not that action item is
"closed", "open", or "in progress."

I would like to conditionally format the column with dates with red font if
the date is in the past and the status is not "closed."

Can anyone help me with the formula?
 
M

Max

Assuming data in row 2 down, where col B = real dates, col C = status
you could apply this as the CF, Formula Is (with B2 active):
=AND($B2<>"",$C2<>"",TODAY()>$B2,$C2<>"closed")
Format to taste, ok out. Additional checks (ie $B2<>"",$C2<>"") help to
remove ambiguities for any blank cells. Any good? hit the YES below
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
MS Project. Real progress of the project, % complete 1
Conditional Formatting 6
Conditional formatting dates 3
Cobditional Formatting Rows based on dates in action plan. 0
Conditional formatting with dates 7
countifs Function not giving desired result with date criteria 2
Countif or other formula needed for multiple data/critera results 3

Top