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

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

The feature you are looking for is called "Conditonal
Formatting".........select the cell, then do Format ConditionalFormatting
and follow the menus........

hth
Vaya con Dios,
Chuck, CABGx3



"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