Thank you Roger, it worked great. Unfortunately the powers that be have just
come along and requested a change of criteria.

The request is now as follows:-

If a figure less than 0, to be yellow, but when blank to be white. I have
used your information provided earlier to allow for anything less than 100 to
be orange and anything less than 300 to be red.

Many thanks.

Ellie

"Roger Govier" wrote:

Hi Ellie

Mark the range of cells you wish the formatting to apply to
FormatConditional FormattingCell value ischoose from dropdown Greater
than800 set Format Red
Add
Repeat using Greater than 300 Format Orange
Add
Repeat using Greater than 0 Format Green

--
Regards

Roger Govier


"Ellie" wrote in message
...
I have a spreadsheet which I require the numbers 1-300 to be green,
301-800
to be orange and anything 801 and in excess to be red.

The only way I seem to be able to do this is by establishing a sheet,
which
I hide within my worksheet, listing consecutive numbers in 3 separate
columns
and naming green, orange and red and using the formula is aspect of
conditional formatting along with a countif formula.

Is there an easier way of doing this, as there are occasions when the
ranges
are changed?

Many thanks for any help offered.