I need to be able to select any cell in my worksheet and it highlight the whole row. I had found a macro that worked when i entered the formula, =ROW()=$A$1 into conditional formatting. It worked fantastically but i some how managed to delete the macro and Ive searched the web and cant find anything that works.
HELP!!!!