T Tiny Mar 4, 2008 #1 I need to have the content of a cell highlight and bold if the product/sum is +/- 10% of the target number.
I need to have the content of a cell highlight and bold if the product/sum is +/- 10% of the target number.
M Max Mar 4, 2008 #2 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 ---
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 ---
