Here's a play you can try out ..

Assuming the numbers to be conditionally formatted are in say, B2:B20
(to be compared with immediate left adjacent numbers in A2:A20)

Select B2:B20

Click Format Conditional Formatting

Under Condition 1:
Formula is: =AND(B2-A2<=0,B2<"",A2<"")
Format: Red fill

Under Condition 2:
Formula is: =AND(B2-A20,B2-A2<2,B2<"",A2<"")
Format: Amber fill

Under Condition 3:
Formula is: =AND(B2-A2=2,B2<"",A2<"")
Format: Green fill

Click to OK out.

Test it out ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Maliya9" wrote:
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!