>Today() Conditional Format Help

L

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
 
K

Klatuu

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.
 
L

LJG

Cheers Guys, working fine now

Les

Klatuu said:
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.
Click to expand...
 
Top