VBA highlight

[christian2016]

Hi Guys,

I have tried a few macros to highlight the active cell.

Issue i have is that any conditional formatting or previous coloured cells will disappear once I highlight that cell and then click on another cell.

If anyone can help on how to write a VBA code to highlight the active cell with out removing any existing conditional formatting or previous coloured cells that would be great.

Thanks

 

[Michael M]

VBA code to highlight the active cell with out removing any existing conditional formatting

I don't believe there is a simple way to do this
You will have to write a macro to reapply the CF when the cell is not active !!

 

[tonyyy]

christian2016,

If you're just trying to make the active cell more visible, you might consider this workaround...

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Cells.Count = 1 Then
    Range(Cells(Target.Row, Target.Column + 1), Cells(Target.Row + 1, Target.Column)).Select
    Target.Activate
End If
End Sub

Selecting a cell will now actually select 4 cells, with the active cell always in the upper left. No change in color, but easier to see than just a single cell.

Cheers,

tonyyy