Forum Discussion
Solved
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
=AND(H2="APPROVED",OR(TODAY()>G2,TODAY()+30=G2))You can try this rule for conditional formatting.
=$H$2:$H$23This is the range the formatting applies to in the example.
=AND(H2="APPROVED",OR(TODAY()>G2,TODAY()+30=G2))You can try this rule for conditional formatting.
=$H$2:$H$23This is the range the formatting applies to in the example.
- Amazing! Thank you so much!
