Conditional formatting comparing two lists of different sizes

[Steffen_DK]

I'd like to have some conditional formatting that marks List A when the value is found in list B.
See attacthment.

[AYData]

For each conditional format, you make a rule that looks at the value you want to match, then select the range in which those values are present.

[Steffen_DK]

Thx. But if one list is 100 cells and the other is 30, that's gonna be a lot of rules hmm...
They don't need to be given different colors if that helps anything.

[FDibbins]

Try this...

1. highlight the range you want to apply the conditional formatting to (B3:B6)
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =HLOOKUP(B3,$I$2:$L$2,1,0) format fill as neded

[AYData]

removed cos it was wrong

[Steffen_DK]

Knew there had to be a simple solution, great!

[FDibbins]

Happy to help and thanks for the feedback