Can colors be associated with certain numbers (1=red;2=blue)?

[Guest]

I'm working on a spreadsheet and I want certain colors to be associated with
certain numbers (1 would = red; 2 would = blue, etc.). How do I do this?

 

[Mark]

I'm working on a spreadsheet and I want certain colors to be associated with
certain numbers (1 would = red; 2 would = blue, etc.). How do I do this?

Can you be more specific about the use you have in mind? I can think
of two different methods that may apply, however choosing one over the
other would depend on the specific application you intend. Please
elaborate...? In short, you will use either Conditional Formatting or
a Custom Function using VBA.

Lemme Know...

 

[Guest]

I don't think conditional formatting will work, but I don't know enough about
it to say for sure. What I'm doing is rating certain statments where 1 is
excellent, 2 is good, 3 is needs improvement, etc. I wanted to be able to
enter a "1" and have that cell automatically be blue colored. Does that make
sense?

 

[Mark]

I don't think conditional formatting will work, but I don't know enough about
it to say for sure. What I'm doing is rating certain statments where 1 is
excellent, 2 is good, 3 is needs improvement, etc. I wanted to be able to
enter a "1" and have that cell automatically be blue colored. Does that make
sense?

Sorry it took so long to get back to you. I rarely have access to the
internet. Yes you can use conditional formatting as your solution. do
the following:

1) Select the cell you want to have the color changing behavior in.
2) Navigate through...FORMAT...CONDITIONAL FORMATTING...
3) Select "Cell Value Is" from the first drop down list on the left.
4) Select "Equal To" from the second drop down list.
5) Enter "1" as your value.
6) Now enter the formatting you want for that occassion. Which I
believe would be something like...FORMAT...PATTERNS...and select the
hue of blue you want.

You may apply up to 3 conditions like this. Do the same thing for the
rest just adjust the value in step 5 and the color obviously...