Headings

p45cal · #1 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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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