Hi everyone,

I'm new to the forum and have been searching around for a way to color cells based on a range of text. For example, I would like to enter a number of cities in a column and based on the region they are in the cell color would change. So, if I entered Chicago, Boston or New York those cells would be blue. If I entered Los Angeles, California or San Jose, the cells would turn red. I don't want to enter another column for region and I don't know macros and all that. I do know a little about the rules within the conditional formatting. I figured out how to make a cell color change for one city but I don't to make 50 rules when I could do 4. Is there a way to make a formula within the rule to capture for a range of cities that would change to one color?

Please be specific as I am not a pro when it comes to the formulas.

Thanks in advance