Excel: value changes cell color

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Couriant

Thread Starter
Trusted Advisor
Spam Fighter
Joined
Mar 26, 2002
Messages
35,698
First Name
James
Is there a formula to make a cell change color when that cell has a specific numeric value? IE:

I have a small table. The total value column (say D5 - D10) is the cells I want to be color coded. D5 has the value 5. D6 has 6, D7 - 7, D8 - 8, D9 - 9, D10 - 10. Any cell that has a value of 5 and under is colored red, 6 - 8 is yellow and 9 and over is green so therefore D5 should be red, D6 to D8 is yellow and D9 - D10 is green.

Attached is an example.
 

Attachments

Joined
Aug 17, 2003
Messages
17,584
Under Format - Conditional Format

You should be able to accomplish what you need. It has 3 conditions to test for to apply your choice of cell format.
 
Joined
Aug 5, 2003
Messages
47
You can also squeeze in a 4th color by making the base color of the cells a certain default. So, make them all red, then set the first condition as >6 and <8 = yellow, etc.
 

Couriant

Thread Starter
Trusted Advisor
Spam Fighter
Joined
Mar 26, 2002
Messages
35,698
First Name
James
A long overdue thank you to both of you :) it's the second time that I had to do this and i forgot it, so I came back to look for it :D

Again thank you! :D
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top