VBA code to highlight the individual column in range based on current date

**UNNI_UNNI** · 01-07-2023, 03:18 AM

Gents,

I am searching for highlighting the individual column in range with respect to the current date.

My referenced area is $G$4:$OL$61

Considering G4:G61 as first range of cells in column G and this range falls on Jan 1-2023.

Today-Jan 7-2023 - the range is M4:M61. I wish this range of cells to be highlighted at the extream border(not all cells).

On next day the next range of cells to be highlighted similarly

Much appreciated, Thank

**vichopalacios** · 01-12-2023, 02:31 PM

Try this

Please Login or Register  to view this content.

VBA code to highlight the individual column in range based on current date

LinkBack

Thread Tools

Rate This Thread

Display

VBA code to highlight the individual column in range based on current date

Re: VBA code to highlight the individual column in range based on current date

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Highlight Sheet based on Current Date?

Highlight column based on current hour

[SOLVED] Conditional Formatting - Highlight WHOLE COLUMN based on the cell containing current date

Highlight Rows Based on Date Range Using Static Date and Current Date

[SOLVED] VBA code to look at a column and see if nil or not, if nil, to add the current date.

[SOLVED] Selecting data from a date range based on the current date

Highlight Only Current Week Based on Date

Bookmarks

Bookmarks

Posting Permissions