Conditional Format Formula

Hello all,

I'm trying to create a conditional format for an excel table.

Sheet 1 will contain various data. Column B will contain specific data that it will be searched through. For this example, I will use Apple, Orange, Banana.

Sheet 2 will contain other data. What I want it to do is search through a specific table on that page (let's use F5:I10 as the table example). In this table, in column H, I want it to search to see if anything of those details appear on Column B of Sheet 1. If it does, I want it to highlight that row.

I've attached a mock up of what I'm looking for with notes.

Apply this formula to the entire column H on your sheet 2. Change Sheet1 as needed. If your sheet 1 has a space in it, you have to enclose your sheet name in single quote ' '

=COUNTIF(Sheet1!$B:$B,H1)>0

Thanks. It seems to be mostly working... but only highlighting the cells in column h. I'm hoping it would highlight the whole row of data.

Then apply this to the entire range of columns:

=COUNTIF(Sheet1!$B:$B,$H1)>0

Beautiful! Thanks you so much for your quick help.