Color cells according to its nature

[YZ1675]

Dear all,
Happy to join mrexcel !

I have an brain teaser with VBA. I want to create a macro that will color:
- Hard coded cells in blue police.
- Formula (ex: vlookup): In black police.
- Linked cells (ex: =Sheet1!$B$5): In green police.

Do you have a code that could work out ?

Many thanks in advance.

 

[BSALV]

select all cells of your worksheet or in a range
F5>Special>Constants>OK
right mouse Format>textcolor>blue

same for the formulas, but the difference between both ?

 

[YZ1675]

Thanks for you reply !

Actually, I would like to automate the program to do it with a multisheets excel without doing it for all sheets.

The difference is just that I want to have a specific color for formulas with the sheet that I use (in Black) and another specific color for formulas that are linked with other sheets.

Best,

 

[BSALV]

automate ?? Tuff !!!
You can program something in VBA and run that once in a while

 

[YZ1675]

Allright !

And do you know how to select only constant with a number please ?