Forum Discussion
Solved
How to color cells based on two values
Hi, I have a spreadsheet where the C column different text values and the F column has dates. I'd like to have a formula saying "if C2 has "new referral " and F2 is older than 7 days then hig...
=AND(C2= "New Referral",F2<=TODAY()-7)This rule for conditional formatting works in my sheet.
=AND(C2= "New Referral",F2<=TODAY()-7)This rule for conditional formatting works in my sheet.
OliverScheurich ahh thanks 🙂 i put an extra ) at the end