Highlight Row and Column headers of active cell

  • Thread starter Thread starter alex.hatzisavas
  • Start date Start date
A

alex.hatzisavas

Hi folks.

What I'm going for is highlighting the Row and Column *headers* of the
active cell.
E.g. if the Active Cell is E5, I'd like the E and the 5 to be
highlighted.

Presumably the code will be linked to the SelectionChange event,
couldn't get anything to work though.
Any quick fixes wizards?

Regards
 
Alex,
That is the normal behaviour of Excel anyway.
In XL2000, the letter/number are Bold, but in XL2002 the header is
column/row is in a different colour.
Not much you can do about changing that, unless you create your own header
columns/rows in A:A and 1:1 and colour those.

NickHK
 
Hi Nick, thanks for that.

I got Excel 2002.
The highlighting of the Column and Rows headers is grey.

Any way to turn it into funky orange or sth.?
Couldn't find anything under Tools > Options.

Regards
 
Alex,
AFAIK, nothing in Excel.
If it's your own system, maybe play with the Control
Panel>Display>Appearance>Scheme and/or Item.
Not sure if XL reads from these settings though.

NickHK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Highlight Cells in Active Row 5
Highlight row and insert text on click 3
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
highlight row of active cell 6
Select rows equal to filter and highlight row 4
Saving format detail of entire row/column 2
highlight row 4
Row number and Column number 2

Back
Top