+ Reply to Thread
Results 1 to 6 of 6

Highlight Group of Dates if Dates Match List of other Dates

  1. #1
    Registered User
    Join Date
    10-10-2012
    Location
    Sydney
    MS-Off Ver
    Excel 2010
    Posts
    69

    Highlight Group of Dates if Dates Match List of other Dates

    Hi there,

    I have a set of dates in column A, and I want to highlight dates in column C if they match dates the dates in column A. I have created a defined name of the dates in column A called dates and I have tried a few things out but I can't figure it out. I want to have just one conditional rule not a rule for each cell in column C as this attached document is just a sample of what I want to do on a larger scale. I would really appreciate your support, and thanks for your help in advance.


    HighlightCells.xlsx

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    49,726

    Re: Highlight Group of Dates if Dates Match List of other Dates

    highlight the range you want, go into conditional formatting, select new rule, select "use formula", entyer/copy this...
    =ISNUMBER(VLOOKUP(C2,$A$2:$A$38,1,FALSE))
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,035

    Re: Highlight Group of Dates if Dates Match List of other Dates

    Try

    Conditional Formatting
    • Highlight applicable range >> C2:C9
    • Home Tab >> Styles >> Conditional Formatting
    • New Rule >> Use a formula to determine which cells to format
    • Edit the Rule Description: Format values where this formula is true: =COUNTIF(dates,C2)>0
    • Format… [Number, Font, Border, Fill]
    • OK >> OK
    Last edited by jeffreybrown; 10-24-2012 at 07:30 PM.
    HTH
    Regards, Jeff

  4. #4
    Registered User
    Join Date
    10-10-2012
    Location
    Sydney
    MS-Off Ver
    Excel 2010
    Posts
    69

    Re: Highlight Group of Dates if Dates Match List of other Dates

    Thanks to the both of you! Works great!

  5. #5
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,035

    Re: Highlight Group of Dates if Dates Match List of other Dates

    You are very welcome. We are both glad to help and thanks for the feedback

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    49,726

    Re: Highlight Group of Dates if Dates Match List of other Dates

    what Martin said, and thanks for the rep

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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