What is the macro to change background based on numeric cell value

G

Guest

I want that a cell background color will change upon calculating a value.

That is to say, if the calculated value is greater than 1.2, then the
background color of that cell will change to red. Conversely, if the
calculated value is less than 4.0, then the background color of that cell
will change to yellow.

The colors which I want to utilize are red, green and yellow.

Thank you in advance for your assistance.
 
G

Guest

Hi why do not use a conditional format?

HTH
regards from Brazil
Marcelo

"Still learning" escreveu:
 
G

Guest

Hi,

Go to Format > Conditional Formatting... and set your formats for the first
case.
Then click on the Add button and set the conditions for the next and again
for the third case.
 

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

Changing Cell Color Based on Value 2
change the color of cell background based on a result 2
how can I use conditional formatting with formula and 3 poss resul 1
Cell text and background colour dependant on result 1
Auto change background of color based on formula 3
Conditional Sum Based on Cell Background Color 6
format 1
In excel change color of a range of cells based on a cell value 1

Top