Excel macro: color-code based on input, formula, or reference (blue, black, green)

Question

Hello,

Can you help me create or input a macro that will color-code cells in excel according to the following color-scheme (common in financial models)?

Blue - Hard-coded values (text or numbers)

Black - Formulas (example: =VLOOKUP(, =IF(, =OR(, etc.)

Green - References from another worksheet (example: =Sheet2!E15)

I would like to be able to select a range of cells, and then click a macro button on the toolbar that formats the cells in this way.  I am not very familiar with macros or visual basic.

Thank you very much for your help.

Ryan

Answer 1

Sure, no problem.

Thanks,

Virinder

Answer 2

This was very helpful. Could you please tell me what it would be if I also wanted to show cells linking to another workbook as red?

blue = hardcode

black = formula

green = link to another tab ("worksheet")

red = link to another document ("workbook")

Thank you!!