cells and colours

[camb]

Hello.
I am a little stuck. I have a column of cells that represent Amount In Stock (this would be column "K"), and the names and descriptions in the preceding columns.
What I would like to know is, is there a way to get, for example A9:K9 row of cells to change colour to another colour if K9's value is 100 or less?

Thankyou

Camb

[darkyam]

Highlight the cells, go to conditional formatting and create a rule using this formula. =$K9<=100. Then use the formatting tool in conditional formatting to change the color.