On Fri, 17 Apr 2009 03:30:25 -0700 (PDT), alex wrote:

Thanks for your input, Ron.

This xls doc is a simple calculator that sits on a user's desktop.
The user enters different numbers (8 char long) throughout the day
into the same cell (only one number at a time). I would like the fith
character of any number to become a certain color whenever it's typed.

I'll play around with the VBA code that you provided. I don't want
the user to have to envoke a marcro...

alex

Alex,

I don't think you can do that.

You could certainly use event code to avoid your user having to execute a
macro. However, the formatting will not take place until after the entire
number has been entered into the cell. I don't know how to format the digits
as they are being entered.

--ron