Highlight Active Row Not Active Cell

Hello,

I want to highlight the active row, but not the active cell. I want the color of the active cell to remain the color that it was prior to selecting it.

I have a workbook that highlights the row of the active cell using conditional formatting. Any advice? Thanks

Formula:

Please Login or Register  to view this content.

to highlight the active row and the active column, up to the cell that will be in focus (so not the entire row or column), without affecting the existing colouring of the CELL that will be clicked, use this Conditional Formatting:

Please Login or Register  to view this content.