Conditional formatting
 

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

Conditional formatting
 

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