How to highlight an active row within a selected range in excel

Hi guys,

Please first see the attached sample excel file for your review.

I used the conditional formatting to highlight an active row with the function below:

=(CELL("row")=CELL("row",C5))

The problem with the excel function is it still highlights the row even when I click the cell that is not within the selected range.

How can I make the row within the selected range to be highlighted only if I select the cells within the range?

Cheers,