![]() Side Note: I'm also looking for some way to not return an error when a cell in the range is empty. If anyone could let me know how to have this cover a range of various columns and rows that would be greatly appreciated! Here is the VBA code I'm running which currently highlights only column C: Sub different_colourTest2() I need some help getting it to run on multiple columns. I've found a way to do this, although it can only be run on one Column. All the values "Car" would be another color etc. For example all the values "Apple" would be one color. The twist is I want each different value to have a different color. I'm trying to have all duplicates in a range highlighted.
0 Comments
Leave a Reply. |