I have a rather large database, filled with certain color names in certain columns.
I am looking for a code to loop through the range where the colors names are, and replace certain color names with a different name.
Some cells have other data (can be anything) - and those cells should be left intact.
Some cells are empty and should be left empty.
Some of the colors names might have some symbols in them ("." or "/" or "&", etc.).
There are about 80 color names in my real-life database and all need to be changed/replaced with a different name.
I assumed the best way to do it is to use a "for each" loop & "select case" and I struggled with it quite a bit, without success.
I am attaching a sample data base, showing what I need.
Any help/pointers will be greatly appreciated.