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