I am sure variations of this have been asked numerous times, and I have reviewed many of the great responses that deal with this issue. Being new to VBM, I am still not able to get the macro to work as perfectly as I'd like though. Here's what I am trying to do (any assistance would be greatly appreciated!):
For all cells in the Grouped Tabs starting with cell A7 onward, the following:
- If the cell is a formula that only references other cells in that tab, color the font gray
- If the cell is a formula that references other worksheets, color the font red
- If a cell contains both a reference to other cells in that same tab, as well as a reference to another worksheet, color that font purple
- If the cell contains a number (not text) that is hardcoded, color the font blue
- All other cells should be gray font, unless if the cell has a green background, then the font should be white.
Thanks guys and gals x
Bookmarks