VBA trying to colour cell based on value in other cell

Hi Guys and Gals,
I'm only just starting to learn VBA so i may be way off with this but hoping someone can help.
Basically what i'm trying to do is fill the ActiveCell colour based on the value of another cell in the same row.
I dont want to use conditional formatting as once i understand how to make this work, i'll be building formulas into the macro to enter data into other cells etc.

the code I have so far is as follows

Please Login or Register  to view this content.

for reference here's the sheet i'm working with - the goal is that if the value in column L "SUSPEND QTY" of the same row is >1 then colour the cell red
I currently only want it to work on the activecell and nothing more; I'll get it to loop through the list later down the track.
=vba1.JPG

thanks in advance
Pete

If SUSPEND_QTY.Row > 1

This is asking if a row>1, not if a cell value >1

The picture supplied shows the active cell in column Y.

Please Login or Register  to view this content.