Headings

[PomDave]

Hi All,

Is it possible to have a different highlighted colour on the headings i.e. when a cell is selected both the column letter and the row number to be say green.


Best regards


Dave R.

[Logit]

https://www.extendoffice.com/documen...nd-column.html

https://stackoverflow.com/questions/...hout-using-vba

[PomDave]

Hi Logit,

Sorry I've not come back any earlier but had a lot on my plate etc.....

Anyway, thanks for getting back, unfortunately the solutions offered not only highlight the row and column headings associated with the particular cell they also highlight the entire row and column.

What I'm looking for is highlighting JUST the headings, for instance, cell C4 is selected, now I want the 'C' to be yellow say and the '4' also be yellow. Is that possible.

I'm using Office 365 - Excel 2016

Best Rgds,
Dave R.

[Logit]

.
I don't know of a way to accomplish your goal.

I suspect, if it is possible at all, it would require using API calls which is above my knowledge level.

Perhaps someone else will be able to assist.

[p45cal]

I don't think you'll be able to change the existing highlighting in Excels row/column headers, but:

To apply this to row 1 and column 1 proceed as follows:
Select the cells in row 1 that you want the colour to appear in, go into conditional formatting and use the formula:
=COLUMN()=CELL("col")
Choose the formatting you want to see, click OK.



Select the cells in column 1 you want this to apply to, go into conditional formatting and use this formula:
=ROW()=CELL("row")
Choose the formatting you want to see, click OK.


Finally, right click on that sheets tab and choose View Code, then paste the following where the cursor's flashing:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Calculate
End Sub