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