Jun 07 2021 07:35 AM
Is there a way to highlight a cell by just slicking on it?
Jun 07 2021 07:42 AM
See for example How to highlight active cell or selection in Excel?
Please read the notes to learn about the side effects.
Jun 07 2021 10:12 AM
Another option is to use conditional formatting rather than an interior fill. By defining the name 'isSelected?' to refer to
= ISREF(Sheet1!H15 SelectedRange)
[the intersection of the current cell as a relative reference and a range set by the Macro]
one can colour cells using leaving the interior fill unaltered.
The macro is
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Target.Name = "SelectedRange"
End Sub
Jun 07 2021 12:06 PM
Hi Peter,
Thanks - I am familiar with this method, but it has been less than 100% dependable in my experience. I have tried it several times, but it occasionally left cells highlighted after another cell had been selected...
Jun 07 2021 03:16 PM