Assign 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 ?
 
C

Chip Pearson

Use the Conditional Formatting tool from the Format menu.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 

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

Assigning a color to a cell 3
Assigning a color to a cell 3
How do I color one cell and have another cell get same color 1
How to type each letter of the alphabet automatically in a specific color in Word? 0
Assign Macro to a Cell 2
How to Color a Cell Based on a Range of Cells with Colors 1
Conditional Formatting color doesn't show up: 90% 7
change font color depending on cell value 11

Top