software

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.

Format conditional formatting, formula is

=A1lt;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

quot;Tommyquot; gt; wrote in message
...
gt; What do I do, to make cells different colors based on a number I enter.
gt; What
gt; I want to do is any number less than 72 the cell will be red.thank you it worked perfect.

quot;Peo Sjoblomquot; wrote:

gt; Format conditional formatting, formula is
gt;
gt; =A1lt;72
gt;
gt; click format button and select colour, click OK twice, now put a number less
gt; than 72 in A1
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; Northwest Excel Solutions
gt;
gt; www.nwexcelsolutions.com
gt;
gt; (remove ^^ from email address)
gt;
gt; Portland, Oregon
gt;
gt;
gt;
gt;
gt; quot;Tommyquot; gt; wrote in message
gt; ...
gt; gt; What do I do, to make cells different colors based on a number I enter.
gt; gt; What
gt; gt; I want to do is any number less than 72 the cell will be red.
gt;
gt;

Hi Tom...this is called conditional formating.

quot;Tommyquot; wrote:

gt; What do I do, to make cells different colors based on a number I enter. What
gt; I want to do is any number less than 72 the cell will be red.