10/31/2023 0 Comments Iphoto find duplicates![]() In the next step a different color is applied to each value. So, I get a list like "B2" occurs in C20, E25, AG90. The approach I took is to sort all values in the range into a dictionary, recording the addresses of all cells relative to the cell values. Not the main point of this but if someone has an answer for that would be happy to hear it as well. 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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |