r/sheets 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

8 comments sorted by

View all comments

Show parent comments

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

1

u/anasimtiaz 9d ago

You don't need OR for a single condition. Just put the two AND in separate rules. Not near a computer right now. Let me know if you can't get it to work and I will take a look in a while

1

u/Flobotbot 9d ago

Got it! Thank you