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

[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????

 

[Frank Kabel]

Hi
do you want this color change 'during the typing'?

 

[Pac Vac Admin]

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

 

[Jonathan Rynd]

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

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.