Automatically Highlight Column Header

How to automatically highlight column header based on date or text using VBA.

Watch the video below:

Automatically Highlight Column Header

A user wants to open a file and highlight today’s date from the header columns. Her column headers are made up of dates. Every time she opens the file she wishes to highlight today’s date header and start working below this header.

Here’s the complete VBA or macro code to highlight the required column:

Private Sub Workbook_Open()
‘Dim x As Date
Dim x As String
Dim found As Boolean

‘x = Date ‘Use for columns with headers having dates. Remove apostrophe.
x = InputBox(“Enter a string for the header to be selected”) ‘ Use for headers with text. Add apostrophe if you have dates in headers.


Do Until IsEmpty(ActiveCell)

If ActiveCell.Value = x Then

found = True


ActiveCell.Font.Color = vbRed

Exit Do

End If

ActiveCell.Offset(0, 1).Select


If found = True Then
MsgBox “Value found in cell ” & ActiveCell.Address
MsgBox “Value not found”
End If

End Sub

The above code executes to highlight the column headers depending on data types dates and text as soon as the workbook opens.

Automatically Highlight Column Header with Dates or Text

Published by

Dinesh Kumar Takyar

Welcome to! My aim is to help you learn MS Excel including VBA. I always felt that a good way to learn something was to find solutions to problems in that domain. That is why I share these Excel videos with you. Mostly these are questions asked during my corporate training sessions. I've been training individuals and companies in computers since 1991. I did my B. Sc. (Vordiplom), M. Sc. (Diplom) and Ph.D. (Dr. rer. nat.) from Hamburg, Germany. The best thing about solving some of my visitor's questions is that I also gain new insights. For more Excel VBA solutions you may like to visit my YouTube channel: For a structured Excel VBA training course online you can visit:

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.