A Boolean expression
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
|