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

[Pettros]

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.

 

[Wolfshadw]

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

 

[Alabalcho]

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

 

[USAFRet]

Yes, this would have to be done via VBA.

 

[Pettros]

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