Assigning a color to a cell

  • Thread starter Junkyard Engineer
  • Start date
J

Junkyard Engineer

I saw some other post about kind of the same problem but not this way.

I have a risk evaluation formula in a cell. Output range is between 1 and 9

If between 1 and 3, I want to assign the color lightgreen to it
If between 4 and 6 I want to assign the color yellow to it
and red if 7 to 9.

Is this possible within the Function use ? If not, How can I apply that
automatically ? a macro ? How ?

TIA
 
H

Harald Staff

Hi

See menu Format > Conditional format. It has a very helpful wizard.
(Remember to consider what should happen at exact numbers 3, 6, 9.)

HTH. Best wishes Harald
 
J

Junkyard Engineer

thanks :)


Harald Staff said:
Hi

See menu Format > Conditional format. It has a very helpful wizard.
(Remember to consider what should happen at exact numbers 3, 6, 9.)

HTH. Best wishes Harald

and
Click to expand...
 
Top