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

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.

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

Hi why do not use a conditional format?

HTH
regards from Brazil
Marcelo

"Still learning" escreveu:

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.

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

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.
--
Ken Hudson


"Still learning" wrote:

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.