Sign in with
Sign up | Sign in
Your question

can I highlight the row and column label if a cell is selected within a spreadsheet

Tags:
  • Excel 2007
  • Spreadsheet
Last response: in Apps General Discussion
Share
September 16, 2014 11:21:53 PM

Would be grateful if someone can assist.
I wish to highlight the column heading and row label if a cell within a table is selected.
Excel 2007 example of what I want -
Column Headings are in cells C3:J3.
Row labels are in cells A4:A56 and B4:B56.
Data is in cells C4 to J56
eg if cell F7 is selected can I highlight the column heading in cell F3 and row labels for row 7 in cell A7 and B7.

More about : highlight row column label cell selected spreadsheet

September 17, 2014 12:54:43 AM

You could probably write a macro/script to do something like that, but there is no default setting within Excel (that I know of) that will highlight other cells.

-Wolf sends
m
0
l
September 17, 2014 7:15:43 PM

By "highlight" - you mean selecting these cells (thus losing your selection of F7), or just changing formatting on-the-fly whenever you are at F7?

Microsoft' VBA (Visual Basic for Applications) is your friend ;) 
m
0
l
September 17, 2014 7:17:34 PM

Yes, this would have to be done via VBA.
m
0
l
September 19, 2014 1:01:49 AM

Alabalcho said:
By "highlight" - you mean selecting these cells (thus losing your selection of F7), or just changing formatting on-the-fly whenever you are at F7?

Microsoft' VBA (Visual Basic for Applications) is your friend ;) 


yes I meant change the format temporarily eg to yellow highlight which reverts back to previous colour when F7 no longer selected
m
0
l
!