Referencing another Sheet for Conditional Format

[PlumGr8]

So i have cell range on another sheet, say D5 to F25 with data. Simple list on Serial Number (SN1001, SN1002, etc). Is there a way to reference these values from another sheet with conditional formatting to turn a cell yellow is there's a match? Like if Sheet 1 Cell D5 says "SN1001" and Sheet 2 has "SN1001" in the listed range it turns yellow. I know i can do it cell to cell, but i need to reference about 75 SN's and i keep getting a reference error. Any help would be great, thanks.

 

[Joe4]

I guess it was the difference between using ; and , I honestly had no idea that changed between regions.

I believe it is mostly in places of the world like Asia where they use semi-colons instead of commas, but anyone can change their regional settings if they wish.

Office 2019

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[PlumGr8]

I believe it is mostly in places of the world like Asia where they use semi-colons instead of commas, but anyone can change their regional settings if they wish.


I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Sounds good, appreciate the help