Conditonal Formatting a date

[mxmedina1655]

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 · Accepted 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.

[#3]

Amazing! Thank you so much!