Can you change font colour automatically for a cell when you type.

E

earthly_angel

I'm using Microsoft Excel 2003 and wanting to know:

We have an excel document as a customer database and we have a column for
Last Update date - we have the dates as a lime green at the moment... We want
the program to automatically change the colour of the text in the cell to
black when someone types in it.. Is this possible????
 
P

Pac Vac Admin

Hi Frank,
Yes we do want to change the color "during the typing"... Any ideas???
 
J

Jonathan Rynd

Yes we do want to change the color "during the typing"... Any ideas???
Click to expand...

I think you have to use Visual Basic with a Worksheet.OnChange event, and
check whether the target cell is one of the special cells that is color
changing.
 
Top