Look up 'Highlight cells that meet specific conditions' in the Answer
wizard in help
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Niek Otten" wrote in message
...
Use FormatConditional formatting
--
Kind Regards,
Niek Otten
Microsoft MVP - Excel
"Richard" wrote in message
...
I am trying to format a cell so that if a value is greater than 5 the
cell
will be coloured Red, if it is between 2 and 4 it will be Orange and if
it
is
between zero and 1 it will be Green, how do I do it?
I tried to use the IF function but it didn't seem to work.
|