Highlight Rows of selected cells ( continuous or discrete cells )

[smallxyz]

Hi,
By applying formula =ROW()=CELL("row") into conditional formatting, I am able to highlight a SINGLE row by selecting any arbitrary one cell.
But, what if I select a long column of cells and wish to highlight those corresponding rows ?
Anyway to do it in Excel?
Thanks.