It seems like Conditional Formatting is what you need.

Check Debra Dalgleish's website for great instructions and examples:

http://www.contextures.com/xlCondFormat01.html

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"robsalmon6" wrote:

how do I get a cell to change colour dependant upon the value entered into it?
For example if I enter a number between 1 & 7 the cell turns green(whilst
still allowing you to read the number!), 7 to 12 yellow, above 12 red.
This is for a record card to record blood glucose levels for a diabetic to
be able to easily recognise patterns.
I am using excel 2003