Cell Colors

[Tommy]

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.

 

[Peo Sjoblom]

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]

thank you it worked perfect.

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

 

[Help with a Formula]

Hi Tom...this is called conditional formating.