Conditional formatting

[nigeo]

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

 

[Jacob Skaria]

Select the range of cells. Assume this range is ColA.
Goto Home tab>Styles>Conditional Formatting>Manage rules>New rule>Use 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