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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
Use Conditional Formatting (Format > Conditional Formatting): Cell value is
and set your criteria. Click Add to add additional conditions.
 
What nobody has mentioned here is that you must FIRST select the rang
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 u
front, eh?

Their help-search algorithm is apalling.

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

Have a good one.

Mark
Bosto
 
Back
Top