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

G

Guest

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change Cell colour on click 5
Using CF to change colour in cell based on date? 4
Change cell colour 2
How to auto text colour change to green if logical function true? 1
How do I set up automatic colour fill of a cell prompted by text? 1
Change background colour of a row if a particular cell has a value 1
Changing background colour when changing data in a cell 7
Change Cell colour 7

Top