View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nigeo nigeo is offline
external usenet poster
 
Posts: 14
Default 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