Re: Conditional Formatting with formula

It is a new sheet with no data/values on, so there should not be any errors in cell A1 or C1.

This is the error I keep getting.

column A is the numbers

column C is the towns

I manually filled in the color for an example just for more clarifications. I recive new numbers (like 2G000556445) everyday and I want it to automatically color. 

But like Mathetes said, i was trying to hard code it as I want to do it with multiple different numbers and towns and colors. So I'll look for a different way to do it. 

And sorry for my bad english. It is not my 1st language.