+ 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
    96

    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 Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    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
    96

    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)

Similar Threads

  1. Conditional Format: multiple conditions
    By nwpassage in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-31-2015, 02:14 PM
  2. [SOLVED] Conditional format icons based on multiple date conditions
    By fb2003 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-23-2014, 09:21 AM
  3. multiple conditions for a conditional format
    By nerrels in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-27-2013, 08:33 PM
  4. Replies: 3
    Last Post: 11-15-2011, 12:13 PM
  5. Replies: 7
    Last Post: 06-12-2009, 03:56 AM
  6. Conditional format formula with multiple conditions
    By Bazzword in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-04-2008, 03:15 PM
  7. [SOLVED] more conditional format conditions
    By rnc in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-06-2005, 01:05 AM

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