Hi Simon,

Highlight the cells and choose Format + COnditional Formating
Press the Add button twice - this will give you three lines.
1 - Change Between to Less than or Equal to, type 5 - Click Format and
choose Green
2 - Type 6 and 14 - Click Format and choose Yellow
3 - Change between to Greater or Eqaul to, typr 15 - Click Fornat and choose
Red

Judith

--
Hope this helps


"Simon" wrote:

Hi I am looking to format teh colour of cells using their values

ie
equal to or less than 5 Green
6 to 14 yellow
15 and greater red

any help greatly appreciated.