Hi, i have a column with a master list. Underneath it, i have another list. I use conditional formating to highlight duplicate values and color them yellow. Now, I would like to add another list below the second list and format the worksheet so that if the object appears on the second list and the master, it will be yellow. If it appears on the 3rd list and the master it will be a different color (blue), and if that object appears on all lists it will be orange. How do i do that?
Bookmarks