Sure go ahead and give me the information to use sheet event code which you
can supply. It will be a learning adventure for me.

I am also going to check out the website you have listed as well.
Thank you so much!

"Gord Dibben" wrote:

How many letters are you talking about?

Using CF as Max points out you can get 3.

If more you can download Bob Phillips' CFPlus which allows for 30

http://www.xldynamic.com/source/xld.....Download.html

Or use sheet event code which I can supply if you want to go that direction.


Gord Dibben MS Excel MVP

On Wed, 28 Nov 2007 07:58:01 -0800, Senie
wrote:

I am trying to produce a formula as to where I key in a specific letter and
the cell will turn to a specific color. for example: if I type in the Letter
"A" the cell the letter is typed in will turn to the color Light Blue.