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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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????
 
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.
 
Back
Top