You would use Conditional Formatting to do this - available on the
Format menu. Just follow the Wizard through and choose the Patterns
tab for background colour.

Hope this helps.

Pete

On Dec 8, 1:52*pm, 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.