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.
Bookmarks