I am trying to change my font colour too blue I change it use it in one box
then it automatically goes back to black. Can I have the font not set to
automatic
Can someone please help as I need the font too be blue for now then to be
able to change it again too pink but after just one selection it always
defaults too black

newbie

Pre-select all the cells you want to have blue-fonted then
FormatCellsFontColor...select the blue button on the color chart.

If you want blue font to be default for all cells on the
worksheet.....FormatStyleNormalModify. Do the blue font selection and OK
your way out.

Gord Dibben Excel MVP

On Thu, 6 Jan 2005 16:01:03 -0800, newbie <newbie @discussions.microsoft.com
wrote:

I am trying to change my font colour too blue I change it use it in one box
then it automatically goes back to black. Can I have the font not set to
automatic
Can someone please help as I need the font too be blue for now then to be
able to change it again too pink but after just one selection it always
defaults too black