Conditional Formatting based of another cell

Closed
Delightful2k4 Posts 1 Registration date Tuesday February 10, 2015 Status Member Last seen February 10, 2015 - Feb 10, 2015 at 04:27 PM
TrowaD Posts 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen September 12, 2022 - Feb 16, 2015 at 11:52 AM
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

TrowaD Posts 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen September 12, 2022 523
Feb 16, 2015 at 11:52 AM
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