it's not a script.
in layout mode, select & make the field FILL as red (default because the date is empty) in the Inspector
then while the field is still selected, choose the conditional formatting with formula
NOT IsEmpty ( dateField )
and set to green fill
now the field will always be red background, but change to green once there is a date in that field.
Thanks very much beverly,I was sort of on the right tracks but not thinking far enough outside the box!!
Prettty obvious when you see it as you have explained.
no worries! Sometimes I have to think backwards when dealing with Conditional Formatting and Hide object when formulas. lots of "NOT" in those formulas.