apply conditional formatting

[jimh]

How do I apply conditional formatting that evaluates two criteria. For
instance I need the field to change colors if the the date = today and
Completed = no

 

[Marshall Barton]

How do I apply conditional formatting that evaluates two criteria. For
instance I need the field to change colors if the the date = today and
Completed = no

Use the Expression Is: option.

The expression might be something like:

Not [Completed] And [datefield] = Date()

Don't ask me why, but the [ ] are necessary arounf the field
names, even if they are pure alphanumeric names.

 

[jimh]

That was it. Thanks, I ran out of ideas to try

How do I apply conditional formatting that evaluates two criteria. For
instance I need the field to change colors if the the date = today and
Completed = no

Use the Expression Is: option.

The expression might be something like:

Not [Completed] And [datefield] = Date()

Don't ask me why, but the [ ] are necessary arounf the field
names, even if they are pure alphanumeric names.