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
I have not understood this part ... what actually this macro is doing ......
Can i make this work w/o macro .....
??
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
Code:
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 .....
??