Select the range of cells. Assume this range is ColA.
Goto Home tabStylesConditional FormattingManage rulesNew ruleUse a
formula to determine which cells to format
Enter this formula in the box below:
=ABS(E1)20.1%
Click the Format button


Add 2nd condition
=ABS(E1)10.1%
Select the desired style(s) Amper

Add 3rd condition
=ABS(E1)0%
Select the desired style(s) Green
If this post helps click Yes
---------------
Jacob Skaria


"nigeo" wrote:

I have a cell containg a % result.

I need to know if the result fits a certain criteria as i need to format cell.
The criteria is:
<-20.1% = Red
Between -20% & -10.1% = Amber
Between -10% & 10% = Green
Between 10.1% & 20% = Amber
20.1% =Red--

Can you telll me what function / formulas /conditional formating i need to
use to achieve this, into my 2nd day trying to sort it out,
Using excel 2007

Thanks


nigeo