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
Ol'Hippie Apps General Discussion 0
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
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