Forum Discussion

Brass Contributor

Jun 20, 2018

Conditiona Formating vs VBA code

Good Evening all, I have a problem I need t make an working expiry sheet. in conditional formatting I am using =Today() but it only works when I press apply. i input expired dates and they don'...

excel

Macros and VBA

Matt Mickle

Bronze Contributor

Jun 25, 2018

Try this:

Private Sub Workbook_Open()
    Dim Edate As Date
    Edate = Format(Date, "DD/MM/YYYY") '
    If Date > Edate + 2 Then
    End If
End Sub