In Excel, when a cell is selected, the row and column headers are highlighted by going bold, so you can see which row and column you are in.
Is there a way of actually highlighting the entire row and column of a selected cell by changing their colour? i.e. when E6 is selected, all cells in column E and all cells in row 6 are highlighted in red, for example?
Any help gratefully received.
Is there a way of actually highlighting the entire row and column of a selected cell by changing their colour? i.e. when E6 is selected, all cells in column E and all cells in row 6 are highlighted in red, for example?
Any help gratefully received.