+ Reply to Thread
Results 1 to 3 of 3

Conditional formatting multiple cells based on multiple cells

  1. #1
    Registered User
    Join Date
    04-18-2014
    Location
    Maryland
    MS-Off Ver
    2013
    Posts
    32

    Conditional formatting multiple cells based on multiple cells

    I'm not sure if this is possible or if there's a better way to do it than what I'm currently thinking.

    I have a data set comparing medical orders placed in our system to our staff's individual records of orders placed. e.g.

    date name mr# test 1 ordered test 2 ordered test 3 ordered test 4 ordered
    2/20/2014 jane doe 123456789 2/20/2014 7/5/2014 11/30/2014
    4/1/2014 jane doe 123456789 2/20/2014 7/5/2014 11/30/2014
    3/5/2014 john doe 987654321

    What I would like to do it have a way to automatically find any rows in which "date" is not equal to "test 1 ordered" or "test 2 ordered" or "test 3 ordered" or "test 4 ordered"

    I was thinking conditional formatting would be an easy way to do this, but I haven't had any luck yet. If anyone knows of any other solutions, please let me know.

    Thanks!

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    HOME: Excel 2007 - WORK: Excel 2013
    Posts
    7,003

    Re: Conditional formatting multiple cells based on multiple cells

    Select A2 (the date)

    Conditional Formatting
    New Rule
    Use a formula to determine...

    =(COUNTIF(D2:G2,"="&A2)=0)

    Format as required
    Use Format painter (paintbrush icon) to copy to other cells
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    04-18-2014
    Location
    Maryland
    MS-Off Ver
    2013
    Posts
    32

    Re: Conditional formatting multiple cells based on multiple cells

    Thanks! That works perfectly.

+ 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. [SOLVED] Conditional Formatting based on multiple strings in multiple cells
    By lily_ruiz_06 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-27-2013, 04:23 PM
  2. Conditional Formatting Multiple cells based on 2 cells
    By Louis Markowski in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 03:05 AM
  3. [SOLVED] Conditional Formatting Multiple cells based on 2 cells
    By Louis Markowski in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 02:05 AM
  4. Conditional Formatting Multiple cells based on 2 cells
    By Louis Markowski in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-05-2005, 10:05 PM
  5. [SOLVED] Conditional Formatting Multiple cells based on 2 cells
    By Louis Markowski in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-01-2005, 01:05 PM

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