conditional formatting

[michele]

Hello boys, I need help with conditional formatting.


I have two date fields. scheduled date and place.
when the scheduled date is less than today, I put a conditional formatting.
how do I date field when the other place is filled, remove the conditional formatting of the other field.

Michele.

[June7]

You are doing this on a form? Using the Conditional Formatting dialog?

The conditional formatting is on which control?

I don't understand the question 'how do I date field when the other place is filled'?

[michele]

I used conditional formatting in a field of a subform. Field below Date (), then color orange.
works. But how do I get another date field is filled, in the same subform, the orange field, run out of color.

[June7]

Sorry, still not comprehending: "But how do I get another date field is filled, in the same subform, the orange field, run out of color."

[michele]

if the date of field1 is greater than today then field1= white
but

if the date of field1 is less than today, and if the date has no value field2 then field1 = orange
but
If the date of a field is less than today, and if the date is the field2 value then field1 = white

[June7]

For orange, try:
Expression Is: [field1] < Date() AND IsNull([field2])

everything else will be white.

Assumes field1 does not have time component.

[michele]

It worked. Thank you.