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

Pettros

Estimable
Sep 17, 2014
2
0
4,510
0
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.
 

Pettros

Estimable
Sep 17, 2014
2
0
4,510
0


yes I meant change the format temporarily eg to yellow highlight which reverts back to previous colour when F7 no longer selected
 
Thread starter Similar threads Forum Replies Date
D Apps General Discussion 1
A Apps General Discussion 1
O Apps General Discussion 3
H Apps General Discussion 1
H Apps General Discussion 1
J Apps General Discussion 11
T Apps General Discussion 3
B Apps General Discussion 1
M Apps General Discussion 5
A Apps General Discussion 1
C Apps General Discussion 1
T Apps General Discussion 2
B Apps General Discussion 3
A Apps General Discussion 4
gloege Apps General Discussion 2
G Apps General Discussion 2
S Apps General Discussion 4
S Apps General Discussion 3
M Apps General Discussion 1
A Apps General Discussion 4

ASK THE COMMUNITY