Forum Discussion

Bruce Land's avatar
Bruce Land
Copper Contributor
May 08, 2018

Conditional formatting for items + or- a tolerance limit

Hi

I am new to Conditional formatting and am wanting to highlight calculated items where they are > or < acceptable tolerances from budget and in a way that the tolerances can be altered e.g. =+/-7.5% or 10%.

Can anyone assist me please

Thank you

Bruce

1 Reply

  • Hi Land

     

    Please go through the attached file. 

     

    Just change the values in bold as per your criteria.

    here my assumption is +-7.5 so in the function its reflecting as 0.075 

     

    =IF(AND(C1>=A1-(A1*0.075),C1<=A1+(A1*0.075)),"YES","NO")

Resources