Complex Conditional Formatting Problem

Originally Posted by Spencer101

Have a look at the new conditional formatting formula in the attached.

If you need help explaining it, let us know.

S.

Thank you for your help. I also need to insert a date in the Storage Date column whenever something is added to the Contents List column. Then, the Expiration Date column needs to have the current date plus 60 days. I'm running the following macro in it, but it is not working. Strange part is, I have used this exact same code in other workbooks, and it has worked. Am I not saving it properly? Is there some setting that is not correct? I have attached the workbook sample you gave me, with the new macro. I have also saved it as a macro enabled workbook.

Private Sub Worksheet_Change(ByVal Target As Range)

If Not Intersect(Target, Range("D2:D61")) Is Nothing Then

Target.Offset(0, 1) = Now()
Target.Offset(0, 2) = Now() + 60

End If



End Sub


I appreciate the help from all the people who reply to my thread.