Inserting a moving date line..

[biffa006]

Hello All..

I have searched this forum and others thoroughly for an answer - no closer than when I started off..

I'm using Excel 2010 on Win7.

I have created a Workbook which is a Planner for scheduled work for the year ahead.
I am trying to figure out how to insert a line or formatted column that highlights the current day/date, updating everytime I open up the workbook.

I have attached an image of what I'm trying to achieve. I have manually formatted this column as an example. I would like this formatting to follow each day to day.

I have seen this before so I know it is possible.
Any help would be extremely appreciated!

 

[matttclark]

Using conditional formatting is one option.

Select the range of cells that you want the color to show, in this case it looks like it starts on D3.

Find the Conditonal Formatting itme on the HOME menu.
Select New Rule
Under Rule Type, Use a Formula to determine which....

Enter this in the formula

=IF(D$4=TODAY(),TRUE, FALSE)


Select the format button and choose your color

 

[MickG]

Perhaps:-

Private Sub Worksheet_Activate()
Dim Rng As Range
Dim Dn As Range
Range("D3").Resize(100, Columns.Count - 4).Interior.ColorIndex = xlNone
Set Rng = Range("D4").Resize(, Columns.Count - 4)
    For Each Dn In Rng
        If Dn = Date Then
            Dn.Resize(100).Interior.ColorIndex = 3
            Exit For
        End If
  Next Dn
End Sub

 

[biffa006]

Thank you so much matttclark..

This does exactly what I requested!!

Thank you kindly..

Using conditional formatting is one option.

Select the range of cells that you want the color to show, in this case it looks like it starts on D3.

Find the Conditonal Formatting itme on the HOME menu.
Select New Rule
Under Rule Type, Use a Formula to determine which....

Enter this in the formula

=IF(D$4=TODAY(),TRUE, FALSE)


Select the format button and choose your color

 

[devilprince_ixi]

-- removed inline image ---

 

[devilprince_ixi]

can u code something like
if i input a start date and finish date an OLE bar line will be drawn instead.