Conditional Formatting for Date Field

  • Thread starter Thread starter Mary
  • Start date Start date
M

Mary

I have a report with three date fields. I would like to have each of
them highlighted if they have no data, or are null. I cannot seem to
get that done. Can you help me?
 
Mary said:
I have a report with three date fields. I would like to have each of
them highlighted if they have no data, or are null. I cannot seem to
get that done. Can you help me?
Click to expand...


Use a custom format on the date text boxes:

d mmm yyyy;;;[RED]"Missing"
 
Marshall Barton said:
Mary said:
I have a report with three date fields. I would like to have each of
them highlighted if they have no data, or are null. I cannot seem to
get that done. Can you help me?
Click to expand...


Use a custom format on the date text boxes:

d mmm yyyy;;;[RED]"Missing"
Click to expand...

Thanks, Marshall... that is a perfect fix!
Mary
 
Back
Top