conditional formatting

T

Tiny

I need to have the content of a cell highlight and bold if the product/sum is
+/- 10% of the target number.
 
M

Max

Tiny said:
I need to have the content of a cell highlight and bold if the product/sum is
+/- 10% of the target number.
Click to expand...

Use AND to define the tolerance range
Indicatively, you could use something like this as the CF formula:
=and(a1>=0.9*Target,a1<=1.1*Target)
where Target is a defined name (single cell) housing the target number
 
Top