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

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!
 
G

Guest

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

LTUser54

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Color a Cell Based on a Range of Cells with Colors 1
Trying to change the background of a cell if I type a certain wor 3
Conditional Sum Based on Cell Background Color 6
format 1
What is the macro to change background based on numeric cell value 2
Is there a way to change the color 3
Changing Cell Color Based on Value 2
Conditional Formatting for multiple cells 2

Top