Hi

I was trying to highlight specific rows and columns with conditional formatting and this formula

=COLUMN()=CELL("col")
=ROW()=ROW("row")

and VBA lines

Application.ScreenUpdating = True

It's working fine and it highlights the rows and columns when I click on any cell.

But this is highlighting all columns that has the same formula in the worksheet.

The result I'm looking for is exactly the same but only highlighting the range within a chosen range in the same worksheet.

Say: group of A1:10 if I click in between it will highlight only that column within that group only, and another group say A20:A30 when I click in between it will only highlight A20:A30 then A1:10 is not highlighted. And hoping I could do the same in rows.

Any help is greatly appreciated.

Thank you very much.