Forum Discussion
Bruce Land
May 08, 2018Copper Contributor
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
Sort By
- Gourab DasguptaIron Contributor
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")