how to chang cell color to text in excel worksheet

G

Greatatulpanday

Hi
I am very new comer in excel VBA programming please send me the
VBA code how to change the cell color to text value.


Atul
 
M

Mika Oukka

Record a macro and do your changes to the selected cell/range and in the
code you will generate something like this
Selection.Font.ColorIndex = 3
where the 3 represents the colorindex for red colour which I chose during
recording.

Hope This Helps

Regards,
Mika Oukka
 
Top