Forum Discussion
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....
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")