Forum Discussion
Search and results display
Hello This is a very newbie question, I'm afraid, and I apologise for that. I've no experience of using Excel other than reading the odd document in .xls format sent to me from time to time. Ho...
That's not out of the box. You may change the color/border of the active cell by adding simple VBA code to the workbook, e.g. form here https://www.extendoffice.com/documents/excel/3635-excel-change-cell-color-when-clicked-selected.html (you may google for other variants)
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 SubIt changes behaviour on
Thank you Sergei for your response. I've decided for the moment to stick with Peter's suggestion, but if I feel adventurous one day I'll certainly try yours out.
Glyn
Glyn, of course, use the solution with which you are most comfortable. In Excel everything could be done by several ways.
