00:00let me get a consensus here how many of you have used conditional formatting to highlight duplicate
00:03values between two tables like this only to find that item duplicate and unique to table one are
00:08also highlighted for example harrison only exists in the first table not the second table well if
00:13you're looking for solution for that this is how you solve it first you're going to right click
00:17on the sheet name view code and after that you're going to go all the way up go vba project
00:22insert
00:22module in here you're going to paste these two vba subroutines if you'd like to have a copy of
00:27this vba subroutine please leave a request on the comment section there's two subroutines here the
00:31first one is to highlight the cell and the second one is to clear the highlights now ctrl s to
00:35save
00:35close your vba editor now we're going to assign a hotkey for those function go developer macro select
00:41highlight go option ctrl h to highlight the cells and then go to clear and options and to clear we're
00:47going to press ctrl c to clear okay and gonna cancel to test select both tables and press ctrl h
00:53to
00:53highlight duplicate if the name like harrison isn't in both table it won't be highlighted press ctrl c to
00:58clear highlights
Comments