Highlight specific text based on a range

[BakerUK]

Hi,

I'm hoping this is possible (and relatively easy) but couldn't find any examples on Google.

I want to use the format cells containing specific text conditional formatting rule, but instead of typing a specific word/text I want it to lookup a range of words on another sheet. The range might change later on so it needs to be dynamic.

Can anyone help?

Thanks

Baker

 

[wigi]

For example, if CF is applied to cell A1:

=COUNTIF(Sheet2!A1:A10,A1)>0

If A1 is found in any of the cells A1:A10 on Sheet2, then the will be formatted.

 

[BakerUK]

For example, if CF is applied to cell A1:

=COUNTIF(Sheet2!A1:A10,A1)>0

If A1 is found in any of the cells A1:A10 on Sheet2, then the will be formatted.

Brilliant, that's done the trick. Thanks.