+ Reply to Thread
Results 1 to 2 of 2

Conditional Formatting based on two conditions

  1. #1
    Registered User
    Join Date
    03-02-2013
    Location
    Phoenix, Arizona
    MS-Off Ver
    Excel 2010
    Posts
    1

    Conditional Formatting based on two conditions

    Here's my issue. I have a spreadsheet for reservations at a Bingo hall. I am trying to conditionally format an entry (the entire row) if it is a duplicate reservation. There are two separate columns for table number and seat number and if both are not identical then it is not a duplicate. I can easily set it up to do this if the table is duplicated or the seat is duplicated, but that is not helpful. I've been playing around with many different functions but I can't seem to get any of them to work. I have minimum to moderate excel knowledge where I understand the language and basis of how the functions work, but I can't construct them without extensive research on Google. This one here just has me stumped...

  2. #2
    Forum Guru Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,067

    Re: Conditional Formatting based on two conditions

    In CF rules use

    =COUNTIFS(A:A,A2,B:B,B2)>1

    where Column A and B are the table number and seat number
    Life's a spreadsheet, Excel!
    Say thanks, Click *

+ 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