|The color code macro simply applies a color map to the selected range very quickly|
to give quick insight into how a spreadsheet is set up. It's particularly useful for
Try selecting a range (or the entire sheet) and run the macro.
The macro includes a bunch of different color designations just to make it easier to
change if you like. I chose to only map values, formulas, and text, but as you will see,
there are other things you can assign colors to (errors, arrays, etc.)
You can also make it a add-in, place it on a toolbar or put it in a custom menu.
For making a custom menu, you can use the MenuMaker which is also provided.