Conditional formatting for certain records

[cath_hopes]

Hi there!

My report lists appointment records for inventory services at rented properties. Each record contains several pieces of information. When two different criteria are met simultaneously for a record, I want to change the font colour for that particular record to red.
How could I do this? Conditional formatting looks too limited to achieve this. I suspect that some VBA code may solve it or query manipulation. Can anyone point me in the right direction?

Thanks v much in advance!
Catherine

 

[boblarson]

Conditional formatting will work. Just change the dropdown from VALUE IS to EXPRESSION IS and type:

[YourField1] = "Whatever Value Here" And [YourField2] = Whatever Value Here

use square brackets around your field names.

 

[pbaldy]

You can have 2 criteria in Conditional Formatting. You'd need to use Expression Is and an expression containing AND.

 

[cath_hopes]

Thanks Bob and Paul, I've done as you both suggested and my issue is solved!
- Catherine

 

[boblarson]

Glad we could assist