Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Jul 2007
    Location
    North Carolina, USA
    Posts
    71
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Conditional Formatting – Access 2007 Form

    When attempting to use the conditional formatting button; I am limited to 3 different equal to options. I have several list items in the field and would like to group two or three items in the same conditional formatting. (i.e. Expired, Removed, Deleted all have Gray field with black text.)
    I have attempted to use “Expired” Or “Removed and “Expired” And “Removed” but neither option works. Is there a way to use conditional formatting with And\Or statements?

  2. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    Lounger
    Join Date
    Feb 2011
    Posts
    43
    Thanks
    0
    Thanked 6 Times in 6 Posts
    You could use
    Expression is [Text2]="A" Or [Text2]="B" Or [Text2]="C"

  4. The Following User Says Thank You to Cronk For This Useful Post:

    swisherink (2012-03-29)

  5. #3
    Star Lounger
    Join Date
    Jul 2007
    Location
    North Carolina, USA
    Posts
    71
    Thanks
    5
    Thanked 0 Times in 0 Posts
    That worked exactly as expected; thank you for helping me figure that out.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •