Some help with conditional formatting

[MrVmaths]

Hey folks. Here's the scenario I have. I have two sheets open; in sheet2 I would like cell A1 to change colour if any cell in a range in sheet1 contains a certain value, eg. cat. I had done this in Google Sheets using the following formula: =not(iserror(vlookup("cat",indirect("sheet2!A1:A20"),1,false))) But it doesn't seem to work in Excel and I can't quite figure out why this formula results in a false output. I have verified that the range does contain the value it's looking for. Any suggestions are appreciated.

[#2]

@MrVmaths 

If the value you are looking for is on A1 youc an use this formula on conditional formatting

=MATCH(A1,sheet2!A1:A20,0)

[#3]

@Juliano-Petrukio Thanks for your response. Unfortunately, the cell I want to be formatted doesn't contain the same thing that I want it to search for.

[#4]

@MrVmaths 

It doesn't matter.

You just need to update the range or cell where you want the formatting to be applied.

[#5]

Thanks again. In your example, it assumes that the word Cat appears in cell A1 of Sheet2, so the formula is looking to see if a cell in the range contains the same value as A1.

In my case the word Cat will only appear in the range in Sheet1.