VBA to check the highlighted row

[prasadyanz]

i would like to know how to copy a value from a row, if any of the cell in that row is highlighted( used conditional formatting, light red fill with dark red text )

for example. i want check the row if it is highlighted, if so , copy the value at "A" and "B" to "R" and "S"


thanks

 

[skywriter]

So is the whole row highlighted or just certain cells and if so which cells?