get a cell to change colour from a value, eg 1to7=green etc
 

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

get a cell to change colour from a value, eg 1to7=green etc
 

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

get a cell to change colour from a value, eg 1to7=green etc
 

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