software

The cell contains a formula to determine the contents. Based upon results, I
would like to color the background of the cell (e.g. if gt;10 color red; if gt;10
amp; lt;20 color yellow; etc.). I have not been successful in finding a solution
using help. Thanks!

Look in Format/Conditional Formatting

quot;Sireofsixquot; wrote:

gt; The cell contains a formula to determine the contents. Based upon results, I
gt; would like to color the background of the cell (e.g. if gt;10 color red; if gt;10
gt; amp; lt;20 color yellow; etc.). I have not been successful in finding a solution
gt; using help. Thanks!

Use Conditional Formatting (Format gt; Conditional Formatting): Cell value is
and set your criteria. Click Add to add additional conditions.quot;Sireofsixquot; wrote:

gt; The cell contains a formula to determine the contents. Based upon results, I
gt; would like to color the background of the cell (e.g. if gt;10 color red; if gt;10
gt; amp; lt;20 color yellow; etc.). I have not been successful in finding a solution
gt; using help. Thanks!

Excellent! Thank you very much and have a great day ! ! !

quot;jirkallaquot; wrote:

gt; Look in Format/Conditional Formatting
gt;
gt; quot;Sireofsixquot; wrote:
gt;
gt; gt; The cell contains a formula to determine the contents. Based upon results, I
gt; gt; would like to color the background of the cell (e.g. if gt;10 color red; if gt;10
gt; gt; amp; lt;20 color yellow; etc.). I have not been successful in finding a solution
gt; gt; using help. Thanks!

Excellent! Thank you very much and enjoy your day ! ! !

quot;SVCquot; wrote:

gt; Use Conditional Formatting (Format gt; Conditional Formatting): Cell value is
gt; and set your criteria. Click Add to add additional conditions.
gt;
gt;
gt; quot;Sireofsixquot; wrote:
gt;
gt; gt; The cell contains a formula to determine the contents. Based upon results, I
gt; gt; would like to color the background of the cell (e.g. if gt;10 color red; if gt;10
gt; gt; amp; lt;20 color yellow; etc.). I have not been successful in finding a solution
gt; gt; using help. Thanks!


What nobody has mentioned here is that you must FIRST select the range
you want formatted before you can use conditional formatting.

I had to search TWICE and experiment for about 10 minutes (with 100%
failure rate) to find that out.

Too bad MS fails to mention pretty crucial stuff like that right up
front, eh?

Their help-search algorithm is apalling.

Then again, my needs are nothing compared to their deisre for total
world domination.

Have a good one.

Mark
Boston--
LTUser54
------------------------------------------------------------------------
LTUser54's Profile: www.excelforum.com/member.php...oamp;userid=33459
View this thread: www.excelforum.com/showthread...hreadid=533751