Forum Discussion
Conditional Formatting with formula
depending on where you live / local setting you may need to use ; instead of , so it might be:
=AND(LEFT($A1;2)="2G"; $C1="KIMBERLEY")
as for 'hard coding' you can use a table on this or another sheet to help define the possible combinations and something like:
=AND(ISNUMBER(XMATCH(LEFT($A1;2); TABLE1[codes])); ISNUMBER(XMATCH($C1; TABLE1[cities])))
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.