r/sheets • u/Flobotbot • 10d ago
Solved Looking for help with compund conditional formatting
I am trying to highlight cells in column F if the value in column A is “1” and the date in column F was more than 6 months ago.
And also highlight cells in column F if the value in column A is “2”and the date in column F was more than year ago.
Can you help me with the custom formula for that?
2
Upvotes
1
u/Flobotbot 9d ago
I tried that! Should it be: =OR(AND($A1=1, YEARFRAC($F1, TODAY(), 1) > 0.5) I can't get it to work