Highlight cells after click on them

[lezawang]

Hi
I have a VBA code (thank you for your help) when I click on a cell it will speak the content. I want to take that further, can I also when I click on the same the color would change to yellow for example and when I click on the other cell the previous cell color will disappear but the new one would be yellow. Is that possible? Thank you very much once again.

 

[GlennJ]

Insert code into the worksheet not a Module.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    With Target
        .Worksheet.Cells.FormatConditions.Delete
        .FormatConditions.Add xlExpression, , "TRUE"
        .FormatConditions(1).Interior.Color = vbYellow
    End With
End Sub

 

[lezawang]

works amazing. Thank you so much.

 

[GlennJ]

Glad I could help