Conditional Formatting question...I think.

[saccharine]

I have two date fields, I have it set so that when you place a date in the first field, the second field will automatically set a date 90 days after. What I need is for the second field to change red when it has been surpassed by the current date.

Thank you.

 

[Meltdown]

Condition
Field Value Is ... less than ... Date()

should do it.

 

[saccharine]

Awesome!!! Thank you for the help.

One last question now that I have that fixed. I would like the date field that turns red when the current date is older to turn back to white when a completion date is put in another field. Here are three fields:

Field 1: Return Date
Field 2: 90 Days Later (Turns red when the current date is older then the listed date)
Field 3: Completion Date (I want that when a date is put in this field, field 2 goes back to white)

Can you help me out?

THanks.

 

[Rich]

You're not storing field2 in a table are you?

 

[saccharine]

I'm not sure what you mean, I used a table to create field 2, then placed it on a form.