SOLVED

Conditonal Formatting a date

New Contributor

Column G is Due Date

Column H is Status

 

I want Column H to turn yellow IF the Status in Column H is "Approved"

AND the date in Column G is TODAY +30 days OR anytime prior to today.

 

I can't seem to get it to work!  TIA

 

2 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

@mxmedina1655 

=AND(H2="APPROVED",OR(TODAY()>G2,TODAY()+30=G2))

You can try this rule for conditional formatting.

=$H$2:$H$23

This is the range the formatting applies to in the example.

due date status.JPG

 

Amazing! Thank you so much!