Dec 24 2023 10:27 PM
I am trying to create a conditional formatting highlight formula that will highlight the cell if the date in C5 is more than 5 years and P5 has a value of more than 15, or if the date in C5 is less than 5 years and P5 is more than 10.
I have gotten to the point of being able to highlight the first part using this formula, but can't figure out how to introduce the second aspect and not get an error.
=AND(TODAY()-$C$5>=(5*365),$P$5>15)
I have played around with trying to make it work with an OR function, but keep getting an error.
=AND(OR(TODAY()-C5>=(5*365), P5>15),(TODAY()-C5<=(5*365), P5>10))
Any help on where I am going wrong is really appreciated!
Dec 24 2023 11:22 PM
SolutionDec 24 2023 11:25 PM
Dec 24 2023 11:37 PM
Dec 24 2023 11:22 PM
Solution