Conditional Formatting on Cursor position

[hsk]

I was searching for coditional formatting on cursor position,

e.g. I want to paint the cell C10 in yellow if cursor is on cell say A8

Thanks to this forum again .... i found one solution

Insert - Name - mycell - Refers to -
=AND(GET.CELL(2)=8,GET.CELL(3)=1)=TRUE

Select Cell C10 - Conditional Formatting - Formula is =mycell - format ....

Now when ever my cursor is on A8 , Cell C10 turns yellow ....

And that's what i am looking for ......

But to make this work i have do

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.ScreenUpdating = True
End Sub

I have not understood this part ... what actually this macro is doing ......
Can i make this work w/o macro .....

??

 

[pgc01]

Hi hsk

The event procedure is forcing a refresh, forcing thus the evaluation of the conditional formatting condition. Without the event procedure, changing cells will not trigger recalculation since you are just navigating.