Conditional Formatting

  • Thread starter Thread starter JamesJ
  • Start date Start date
J

JamesJ

I've a continuous form with 3 fields the row. One is a Date field.
How can I set all 3 field's text color to red if the Date field equals
Date()??
I can set the format for the Date field but I would like the other 2 fields
to
have the text red, also.

Any help will be appreciated,
James
 
Hi -

You can use conditional formatting (Format - Conditional Formatting) for all
three. The condition for the two non-date fields will be "Expression Is" ,
and the expression can refer to the date field in the record:

[mydatefield] = date()

The date field itself will have "Field Is" "Equal To" and Date()

and set the format to whatever you need.

HTH

John
 
James

Try using exactly the same expression in the other two fields as you
are using in the Date field.

HTH

Peter Hibbs.
 
Back
Top