I have a big spreadsheet that has 30 columns. The data is downloaded from an SQL database from time to time.
The row identifying data ( the record number/key ) is in the left most cell.
I often have to move over 10 to 20 columns to view some other data in the same row and sometimes I "loose" which row I am on.
So I highlight the row by selecting the preset Excel row number which higlights the whole row and then use the lower slider bar to go to the correct column to view the data.
However if I wish to select an item of data ( or update a particular cell ) then I loose the highlighting for that row and I can "loose" which row I am on. ( maybe I'm stupid but it does happen )
Can I use Conditional formatting to highlight a row whenever I alight on any data in that row and it stays highlighted until I select another value on another row?