changing the color on range in a column when text is in a certain row

below is the conditional formatting recorded

for String:= I need it to read a string variable. I need it to reference a two digit country code that has been looked up from another sheet.

after, i want to highlight a certain range like A1 to N1

then i want it to do do this for all of Column N.

can i modify this code a bit or do I need to start from scratch.

Please Login or Register  to view this content.

any and all help would be much appreciated.