Conditional Formatting based of another cell

Closed
Report
Posts
1
Registration date
Tuesday February 10, 2015
Status
Member
Last seen
February 10, 2015
-
Posts
2847
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 13, 2022
-
Hello,

I am attempting to do conditional formatting in Excel 2013. I am trying to make Cell C 3 turn red if cell 1 is 25% less or greater than cell 2 and greater than absolute value of 20. Please help.

Thanks,

1 reply

Posts
2847
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 13, 2022
491
Hi Delightful2k4,

So I'm guessing you are looking for the formula to use for conditional formatting.

If I understand you correctly then this will work:
=AND(OR($C$2*1.25=$C$1,$C$2*0.75=$C$1),$C$1>20)

Now, for example, when C1 = 25 and C2 = 20 then C3 turns red.

Best regards,
Trowa
0