>Today() Conditional Format Help

[LJG]

I Have a continuous form that has a due date field, I want to set this so it
changes to Red, background if >today()

I have tried to enter this but it fails...anyone any ideas?

TIA

Les

 

[Allen Browne]

Try:

Date()

 

[Guest]

Use Conditional Formatting from the main menu Format -> Conditional Formatting.
In the first combo, "Field Value Is"
In the second combo, "greater tham"
In text box, date()
Then set your background color for that condition.

 

[LJG]

Cheers Guys, working fine now

Les

Use Conditional Formatting from the main menu Format -> Conditional
Formatting.
In the first combo, "Field Value Is"
In the second combo, "greater tham"
In text box, date()
Then set your background color for that condition.