In Excel is there a function to change a cell's background color?

[Sireofsix]

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 >10 color red; if >10
& <20 color yellow; etc.). I have not been successful in finding a solution
using help. Thanks!

[jirkalla]

Look in Format/Conditional Formatting

"Sireofsix" wrote:

> 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 >10 color red; if >10
> & <20 color yellow; etc.). I have not been successful in finding a solution
> using help. Thanks!

[SVC]

Use Conditional Formatting (Format > Conditional Formatting): Cell value is
and set your criteria. Click Add to add additional conditions.


"Sireofsix" wrote:

> 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 >10 color red; if >10
> & <20 color yellow; etc.). I have not been successful in finding a solution
> using help. Thanks!

[Sireofsix]

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

"jirkalla" wrote:

> Look in Format/Conditional Formatting
>
> "Sireofsix" wrote:
>
> > 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 >10 color red; if >10
> > & <20 color yellow; etc.). I have not been successful in finding a solution
> > using help. Thanks!

[Sireofsix]

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

"SVC" wrote:

> Use Conditional Formatting (Format > Conditional Formatting): Cell value is
> and set your criteria. Click Add to add additional conditions.
>
>
> "Sireofsix" wrote:
>
> > 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 >10 color red; if >10
> > & <20 color yellow; etc.). I have not been successful in finding a solution
> > using help. Thanks!

[LTUser54]

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