Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
coloring todays date
I have rows of data containing date info in dd mm yyyy format on column J in
various sheets. What VB code should I use in the workbook or module code page so that the rows will be highlighted (or yellow colored) containing today's date on column E? TIA |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
coloring todays date
Hi J_J,
Had a similar problem ... adjust the following to your needs : Private Sub Worksheet_Change(ByVal Target As Range) Dim Cell As Range Set Target = Range("J1:J200") For Each Cell In Target If Cell.Value = Now() Then Cell.Offset(0, -8).Range("A1:L1").Interior.ColorIndex = 6 End If If Cell.Value < Now() Then Cell.Offset(0, -8).Range("A1:L1").Interior.ColorIndex = xlNone End If Next Cell End Sub HTH Cheers Carim |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
coloring todays date
Use conditional formating. It's instantaneous and it requires no vba code.
Glen "J_J" wrote in message ... I have rows of data containing date info in dd mm yyyy format on column J in various sheets. What VB code should I use in the workbook or module code page so that the rows will be highlighted (or yellow colored) containing today's date on column E? TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
is there a formula that will subtract todays date from a hire date | Excel Worksheet Functions | |||
Making a date go red, if date passes todays date. | Excel Worksheet Functions | |||
Exel increment date problem wrt todays date. | Excel Worksheet Functions | |||
Create a button that will date stamp todays date in a cell | Excel Discussion (Misc queries) | |||
When I open my past invoice it keeps changing date to todays date | Excel Worksheet Functions |