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
Pettros
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.
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
-
Reply to Pettros
Alabalcho
September 17, 2014 7:15:43 PM
Pettros
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
-
Reply to Pettros
m
0
l
!