conditional formatting in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how do you add a phrase to a field if the filed is blankl, also, can you have
a notifiction sent to you when a date on a spreadsheet has expired?
 
how do you add a phrase to a field if the filed is blankl,
Click to expand...

What "phrase" do you mean? A Comment? A value?

also, can you have
a notifiction sent to you when a date on a spreadsheet has expired?
Click to expand...
Maybe you can apply an open event (date to be tested being say in F1):

Private Sub Workbook_Open()
If Range("F1") < Date Then
MsgBox "Date expired"
End If
End Sub

Regards,
Stefi
 
Back
Top