SOLVED

New Contributor

Conditonal Formatting a date

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

Re: Conditonal Formatting a date

``=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.

Re: Conditonal Formatting a date

Amazing! Thank you so much!