software

here's one I'm sure has been asked many times before...

Column A, contains an option of HIGH, Medium, Low.
Based on what is entered, colour the cell automatically, Red, Yellow, Green.

Anyone got the formula? Or do I need to put some code in? I don't know how
to put code in, so if this is answer, please give brief guide too! Thanks...

Use conditional formatting: Format gt; Conditional Formatting. Set your three
conditions--you need to Add your second and third conditions.quot;Stevequot; wrote:

gt; here's one I'm sure has been asked many times before...
gt;
gt; Column A, contains an option of HIGH, Medium, Low.
gt; Based on what is entered, colour the cell automatically, Red, Yellow, Green.
gt;
gt; Anyone got the formula? Or do I need to put some code in? I don't know how
gt; to put code in, so if this is answer, please give brief guide too! Thanks...


Select all of Column A

Click Format gt; Conditional Formatting

Create three conditions:

Condition 1 = If Cell Value is eqaul to High -- then choose your
formatting options.

Click quot;Addquot; and repeat for other desired conditions.

Profit.--
SlipperyPete
------------------------------------------------------------------------
SlipperyPete's Profile: www.excelforum.com/member.php...oamp;userid=31220
View this thread: www.excelforum.com/showthread...hreadid=521089lt;Formatgt;lt;Conditional Formattinggt;
Choose quot;Formula isquot;
Enter 3 conditions, each having one of the following formulas (assuming cell
A1):

=A1=quot;Highquot;
=A1=quot;Mediumquot;
=A1=quot;Lowquot;

Choosing the format for each, respectively.

--
Regards,
Davequot;Stevequot; wrote:

gt; here's one I'm sure has been asked many times before...
gt;
gt; Column A, contains an option of HIGH, Medium, Low.
gt; Based on what is entered, colour the cell automatically, Red, Yellow, Green.
gt;
gt; Anyone got the formula? Or do I need to put some code in? I don't know how
gt; to put code in, so if this is answer, please give brief guide too! Thanks...