View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Maliya9 Maliya9 is offline
external usenet poster
 
Posts: 7
Default IF statements and conditions

I don't even know if its IF statements I want!

I want Excel to background colour a cell, Red, Amber or Green dependent upon
the data in it compared to the data in the cell immediately left of it.

e.g. if the data is equal, or lower value = red
if the data is higher by 1 = amber
if the data is higher by 2+ = green

Can anybody help? it'll be much appreciated!