+ Reply to Thread
Results 1 to 3 of 3

Conditional format with multiple conditions

  1. #1
    Registered User
    Join Date
    01-11-2012
    Location
    Kent, England
    MS-Off Ver
    Excel 2010
    Posts
    76

    Conditional format with multiple conditions

    Hi Guys

    I have a work rota spreadsheet (attached) that has to change due to working conditions in the current climate. What I need to do is apply conditional formatting to the data in E4:K21 based on the names in C4:C21. I have added single condition formats in the past based on 1 name but now I need Person 1 to 7 to be formatted blue and Person 8 to 14 to be formatted red. I have started doing this individually but the original file is for 3 shifts with about 50 to 60 people. I believe this might increase the size of the sheet making it too slow etc.

    The first thing is; can I apply the format to more than one person at a time (i.e. include Person 1 to Person 7 in the conditional format formula)?
    The second thing is; I need the A/L conditional formatting to show over the colours so is this possible?

    Many thanks in advance. Thanks for looking

    Ross
    Attached Files Attached Files
    Cheers

    Ross

  2. #2
    Forum Expert Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    Office 365
    Posts
    2,913

    Re: Conditional format with multiple conditions

    Key
    Person 1 to Person 7 to O4:O10
    Person 8 to Person 14 to P4:P10

    One color One conditional formatting Formula
    =MATCH($C4,$O$4:$O$10,) => Blue
    =MATCH($C4,$P$4:$P$10,) => Red

    Move AL to the top to overwrite other conditions.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    01-11-2012
    Location
    Kent, England
    MS-Off Ver
    Excel 2010
    Posts
    76

    Re: Conditional format with multiple conditions

    Thanks for the very swift reply Bo_Ry. That looks perfect

+ 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