Forum Discussion
SeanHaggerty
Dec 25, 2023Copper Contributor
Conditional formatting formula using 2 criteria, for 2 different limits
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 t...
- Dec 25, 2023How about do this?
=OR(AND(TODAY()-C5>=(5*365), P5>15),AND(TODAY()-C5<=(5*365), P5>10))
SeanHaggerty
Dec 25, 2023Copper Contributor
That did it! Thanks so much.
Looking at this formula, I can see where I was going wrong with the other one as well.
Looking at this formula, I can see where I was going wrong with the other one as well.
Salposi
Dec 25, 2023Copper Contributor
To calculate the year, this function better
=OR(AND(YEAR(TODAY())-YEAR(C5)>=5, P5>15),AND(YEAR(TODAY())-YEAR(C5)>=5, P5>10))
=OR(AND(YEAR(TODAY())-YEAR(C5)>=5, P5>15),AND(YEAR(TODAY())-YEAR(C5)>=5, P5>10))