thank you it worked perfect.

"Peo Sjoblom" wrote:

Format conditional formatting, formula is

=A1<72

click format button and select colour, click OK twice, now put a number less
than 72 in A1

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"Tommy" wrote in message
...
What do I do, to make cells different colors based on a number I enter.
What
I want to do is any number less than 72 the cell will be red.