conditional formatting
 

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

conditional formatting
 

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

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---