On Sunday, April 26, 2015 at 9:07:23 AM UTC-7, L. Howard wrote:
try:

Private Sub Worksheet_Change(ByVal Target As Range)
Target.Interior.ColorIndex = IIf(Target = "A", 6, xlNone)
End Sub

If this is not the expected soluntion please post more informations


The user will select the cells of choice and run a macro with a short cut key.

So target does not work nor change event'

Howard

Just to add, a user will select cells and run the macro, a color will be installed along with a letter. (probably the persons initial and the color may be a coding thing)

So if I select four cells and hit my Ctrl + q short cut, then cells are yellow with my letter in them.

If I select those same cells later and run the code then no color and no letter.

Howard