CELL COLOR CHANGE WHEN A LETTER IS TYPE IN A CELL

[TOM R]

Hi I'm new to this. I have Excel 2002, I need a VBA code to change the color of a cell when a letter is added to that cell. In column D. D3 to D15 the letters A thru G will be added in a random order. There will be a matching letter in that column. So the letters A and A could be blue , B and B yellow, C and C could be green etc... The pairs need to match the same color. I have a random numbers generator macro that I run to change the I letters in that column, also so I don’t know if it could be added to that or 2 macros could be ran.

EDIT: Changed case - All CAPS is difficult to read - Moderator

 

[Smitty]

Welcome to the Board!

If your number generator is based on a formula you could use a Worksheet_Calculate event. If they're changing based on code, you could add a Select Case structure to your code to match pre-defined cell colors to letters A-G (you could also do that with the Calculate event).

Can we see the code or formula that you have now?

Smitty