Can Access Conditional Formatting have more than one criteria

J.R. Sitman
J.R. Sitman used Ask the Experts™
on
Can conditional formatting have more than one criteria?  e.g. If I want the background color to be red if the Officers name is Williams, or Jones or Smith.  Or the ID is 333, or 5454, or 66544?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
President / Owner CARDA Consultants Inc.
Distinguished Expert 2018
Commented:
Yes, you can use the "Expression Is" to build your expression whatever it may be with as many validations you need.

Personally, I prefer to use VBA, in which case the sky is the limit.  I create a formatting sub and then apply it to the form's current event, and any after update events that can impact the formatting.
J.R. SitmanIT Director

Author

Commented:
Can you give me an example using williams or Jones or smith?
Yes, you can have many conditional rules. First true rule in the list will work.
Look at sample. Rules:
c1There are 2 true rules for second record (both for field with date), resulting color is from first matched rule in the list
c2
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

J.R. SitmanIT Director

Author

Commented:
Thanks
Daniel PineaultPresident / Owner CARDA Consultants Inc.
Distinguished Expert 2018

Commented:
You could create an expression along the lines of
[LastName]='williams' OR [LastName]='jones' OR [LastName]='smith'

Open in new window

J.R. SitmanIT Director

Author

Commented:
Perfect.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial