+ Reply to Thread
Results 1 to 4 of 4

Conditional Formatting - Highlight row-based matches based on data in same row

  1. #1
    Registered User
    Join Date
    01-07-2020
    Location
    Sydney, Australia
    MS-Off Ver
    Microsoft 365
    Posts
    9

    Question Conditional Formatting - Highlight row-based matches based on data in same row

    Hi Forum Users,

    I have created a scheduling template and with the help of other forum users, been able to add conditional formatting to suit specific goals.

    One enhancement I want to implement is to list in a row the people unavailable to be scheduled on a specific day and compare it to the names for that same row of the schedule. If there are exact matches, a conditional formatting rule would highlight them. This would indicate to the scheduler to substitute this person with an individual who is available. Please see attached sample schedule.

    In the G2:Z14 zone of the September 2021 sheet, data validation lists have been created using the named range "Approved_People_All". Conditional formatting has been applied to this zone to fill it with purple diagonal lines if the cells are blank. Based on the sample data in the spreadsheet, Person 01, 04 and are unavailable for scheduling on Wed, September 1. Based on the conditional formatting rule I want to implement, cell B2 would be formatted as it is an exact match.

    Based on the context and information, what formula would I need to use in the conditional formatting rule to achieve this outcome? Please feel free to download and edit the spreadsheet.

    Thanks in advance for your assistance.
    Attached Files Attached Files
    Many thanks,
    Tim

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 for Mac OSX & Windows
    Posts
    7,289

    Re: Conditional Formatting - Highlight row-based matches based on data in same row

    try
    =Countif($G2:$Z2,B2)>0
    Attached Files Attached Files
    Wayne

    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Registered User
    Join Date
    01-07-2020
    Location
    Sydney, Australia
    MS-Off Ver
    Microsoft 365
    Posts
    9

    Re: Conditional Formatting - Highlight row-based matches based on data in same row

    Hi etaf,

    That worked a treat. It achieved the exact outcome I wanted. I appreciate your help very much

  4. #4
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 for Mac OSX & Windows
    Posts
    7,289

    Re: Conditional Formatting - Highlight row-based matches based on data in same row

    you are welcome

+ 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 other cells highlight
    By WaveWalker116 in forum Excel General
    Replies: 3
    Last Post: 11-20-2020, 04:51 PM
  2. [SOLVED] Conditional Formatting - Highlight row based on date in I column
    By mtpockets in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-22-2015, 03:26 PM
  3. [SOLVED] Conditional Formatting - Highlight cell based on two criteria
    By HomerGuy in forum Excel General
    Replies: 3
    Last Post: 01-26-2015, 03:50 PM
  4. Replies: 7
    Last Post: 06-10-2013, 09:39 AM
  5. [SOLVED] Highlight Row based on data on separate sheet - Macro or Conditional Formatting?
    By Richww2 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-09-2012, 06:12 PM
  6. Replies: 2
    Last Post: 02-21-2010, 05:53 PM
  7. Replies: 6
    Last Post: 05-16-2008, 06:28 PM

Tags for this Thread

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