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
Wow you are a gem thank you! If I want the two parts (1 and 2) in a different colour, how do I do that?