+ Reply to Thread
Results 1 to 4 of 4

Conditional formatting highlighting multiple values

  1. #1
    Registered User
    Join Date
    04-22-2013
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    2

    Conditional formatting highlighting multiple values

    Good morning!

    I'm essentially creating a spreadsheet to track lotto numbers for a pool and need to have a conditional formula that will highlight any cell within "C2:I45" if it contains a value equal to "1,4,6,7,8,10,12,13,18,29,30,31,35,36,39,40,48,52,53,56,57,58". I've searched around with no luck and I'm hoping you guys can help.

    Thanks!

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,686

    Re: Conditional formatting highlighting multiple values

    i'm sure they may be a better way but

    OR(C2=1,C2=4,C2=6,C2=7,C2=8,C2=10,C2=12,C2=13,C2=18,C2=29,C2=30,C2=31,C2=35,C2=36,C2=39,C2=40,C2=48,C2=52,C2=53,C2=56,C2=57,C2=58) and copy

    and copy the format
    OR if 2010 version apply to the range C2:I45

    see attached example
    Attached Files Attached Files
    Last edited by etaf; 04-22-2013 at 12:32 PM.

  3. #3
    Registered User
    Join Date
    04-22-2013
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Conditional formatting highlighting multiple values

    worked perfect, thanks!

  4. #4
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,686

    Re: Conditional formatting highlighting multiple values

    excellent - thanks for letting us know

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1