I have a list of names in Column A. These names all have a different
(current) dates next to them in Column B.

Is it possible to use a formula (or conditional formatting) so that when it
is, say 14 days before that date, it changes the colour of the two cellss
(the name and the date) to Red??

Would appreciate any help!

Thanks
alice

I added a new 3rd line

Sub worksheet_change(ByVal Target As Range)

If Target.Column = 23 Then

If IsEmpty(Target) Then Exit Sub

If Target < Cells(Target.Row, 22) Then

ReasonWhy = InputBox("Enter Reason date was Pushed back")
Cells(Target.Row, 24) = ReasonWhy

End If


End If


End Sub

"alice" wrote:

I have a list of names in Column A. These names all have a different
(current) dates next to them in Column B.

Is it possible to use a formula (or conditional formatting) so that when it
is, say 14 days before that date, it changes the colour of the two cellss
(the name and the date) to Red??

Would appreciate any help!

Thanks
alice