+ Reply to Thread
Results 1 to 2 of 2

Conditional formatting based on date on column and cell contents

  1. #1
    Registered User
    Join Date
    05-03-2022
    Location
    Finland
    MS-Off Ver
    365
    Posts
    2

    Conditional formatting based on date on column and cell contents

    Hi,


    I'm hoping someone knows if this is possible: I'm trying to get conditional formatting to highlight cells that match two criteria: specific date on the column and specific cell values.

    I'm linking an example where I've used manual coloring to show what I'm trying to achieve. In the example file, I have six seats from A1 to A6. These seats are further divided into three groups M1 to M3. Each group has specific dates when they are reserved, and that's when I'd like to have them highlighted - but not the rest of the column, unless of course multiple groups have overlapping date info.

    So I guess the logic would go to first check that group M1 is reserved on 6.9 and 9.9.2022; then check that A1 and A2 belong to group M1. Find the columns with the dates, and highlight the cells which contain what belongs to the group M1.

    I'm not even sure anymore at this point if I'm approaching this the right way by using "helper" tables on separate sheet. It's just something that has very often been the key in other problems.

    Thanks all!
    Attached Files Attached Files

  2. #2
    Forum Expert WideBoyDixon's Avatar
    Join Date
    10-03-2016
    Location
    Sheffield, UK
    MS-Off Ver
    365
    Posts
    2,182

    Re: Conditional formatting based on date on column and cell contents

    Well, I had to use some helpers in L9:Q14 with the following in L9:

    Please Login or Register  to view this content.
    I used a white font to hide them. Then I simply used those values in the conditional formatting rules.

    See attached.

    WBD
    Attached Files Attached Files
    Office 365 on Windows 11, looking for rep!

+ 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. Replies: 4
    Last Post: 03-25-2022, 11:51 AM
  2. [SOLVED] Conditional Formatting based on another cell's contents
    By kmlloyd in forum Excel General
    Replies: 5
    Last Post: 09-28-2017, 11:04 AM
  3. Conditional formatting based on contents of another cell
    By Kevska in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-29-2015, 09:54 PM
  4. Conditional Formatting based on cell contents?
    By Cremorneguy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-09-2015, 06:29 AM
  5. Replies: 5
    Last Post: 05-03-2012, 06:06 PM
  6. [SOLVED] Conditional Formatting based on contents in another cell
    By flisters in forum Excel General
    Replies: 3
    Last Post: 03-22-2012, 07:04 AM
  7. Replies: 6
    Last Post: 12-22-2008, 06:16 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