conditional formatting

[Tiny]

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

 

[Max]

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

---