Conditional Formatting for Date Field

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?
 
M

Marshall Barton

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"
 
M

Mary

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
 
Top