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)



You can try this rule for conditional formatting.


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

due date status.JPG


Amazing! Thank you so much!