Conditional formatting

  • Thread starter Thread starter nigeo
  • Start date Start date
N

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--
Click to expand...

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
 
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
 
Back
Top