Chang Color of Cell based on cell text

[gottimd]

I know that I can do Conditional Formula's but I just have 30 different values that the cell text could be, so I was wondering if there was a way to write that in code? It is also used for 30 different varying locations based on refreshed data.

For an example, in Column A, Rows 2-31, will be different city names, which will vary when the data is sorted each time the revenue's are updated. I wanted the Colors of these cells to change based on what the city name is, but there are too many possibilities to use a conditional formula.

One week it maybe this:

Column A
City X= Black
City Y= Red
City Z= Orange
City A= Yellow
City B= Purple

The next week it could be this:

Column A
City A= Yellow
City X= Black
City B= Purple
City Y= Red
City B= Purple

Does this make sense and can it be done?

 

[Zack Barresse]

Well we could go in speculative circles for months and still come up with similar solutions. To get one that really works for you, you're going to need to post a sample of your work. Use the HTML maker (link at the bottom of the page) to give a 15-20 row example of your data (C:I).