IF statements and conditions

[Maliya9]

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!

 

[Stefi]

Have a look at Formats/Conditional formatting!

Regards,
Stefi


„Maliya9†ezt írta:

 

[Max]

Hey Max, thanks for your help...

You're welcome

.. But I wanted Excel to do it
so if a member of my staff types in 1c,
the cell displays 7
and if they type in 4a the cell will display 29 etc...

Think you would need a sub to do the above. Suggest you try a fresh posting
in excel.programming to garner responses from those versed in vba.