Headings

p45cal · #5 08-24-2018, 06:16 AM

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:

Code:

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Applied Styles to Headings in Multi-Level List; now ALL second level headings are 1.XX	NNL	Word	1	08-09-2017 02:52 PM
Numbered headings not working as expected after customising headings	seanspotatobusiness	Word	5	03-03-2017 04:44 AM
Creating new styles and applying numbering to headings - numbering not following from headings	Fuzzyflo	Word	1	07-26-2016 04:34 AM
VBA for Headings	spc94	Word VBA	1	06-09-2015 04:06 PM
Headings	Metamag	Word	5	04-16-2011 09:30 PM