apply conditional formatting

  • Thread starter Thread starter jimh
  • Start date Start date
J

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


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.
 
That was it. Thanks, I ran out of ideas to try

Marshall Barton said:
jimh said:
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
Click to expand...


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.
Click to expand...
 
Back
Top