00:00If you want to create a feature where you can highlight every matching row based on whatever
00:04artists you have selected on the search by column here, this is how you do it. The first thing I'm
00:09going to do is to create a drop-down list for search by artists so that you don't have to
00:13manually type it in there. But there's a series of artists here and you have to get a unique one.
00:18So I'm going to use column L as a temporary data set here to actually get the list of unique
00:24artists.
00:24The formula to do that is equal unique and the first argument in there would be the artist list
00:31itself from a data set. Then you close parenthesis and if you hit enter, it'll give you the list of
00:36all the unique artists here. Now you're going to associate this in your drop-down list. Select cell
00:41C6 here and you go to data from your ribbon. Data validation, data validation. In here, make sure
00:47you select settings tab. On the allow, you're going to change this to list. On the source, you're going
00:52to click on this arrow here which gives you an option to actually select the data set or cells
00:57on your spreadsheet here. Basically, you're going to go and select all the artists lists that you got
01:02as a unique artist list here and you hit enter twice like this and then now you got the pull
01:08-down
01:08menu or rather drop-down list on cell C6 here and if you do this, you can see all the
01:13available
01:14artists that's from this unique artist list here. Just as a test, I'm going to select Isabella here
01:19and you can see it works. Now to associate this with your data set so that it highlights every
01:26occurrence or matching row. Basically, what you do is that you select your complete data set like this
01:31all the way down to the very last row. Let's go all the way up here and after that you're
01:36going to go
01:36to Home, Style, Conditional Formatting and let's do a new rule here. In this new rule here, you're going to
01:43say
01:44use formula to determine which cell to format and on this format formula basically you're going to go
01:50and select equal and then you're going to select this artist here very first one it's going to be
01:56b10 and you're going to press f4 twice like this so that your column b will be fixed but your
02:02row is
02:03variable and you're going to say equal again and then this time around you're going to select this
02:08search by artist cell here which is c6 and after that click on format make sure you're on the fill
02:15tab
02:15and select the color that you like to highlight the row. I'm going to select red like this so it's
02:21obvious
02:22and click ok and ok. Now you can see the selection is already working now if I have to go
02:28ahead and
02:28make changes to say Elijah you can see that every occurrence of the artist Elijah is highlighted
02:35and then if I change to victor you can see all victor atlas rows are selected
Comments