+ Reply to Thread
Results 1 to 3 of 3

Need help with conditional formatting with Vlookup

  1. #1
    Forum Contributor mikehk's Avatar
    Join Date
    09-05-2017
    Location
    Hong Kong
    MS-Off Ver
    Office 365
    Posts
    483

    Need help with conditional formatting with Vlookup

    How can I highlight cells in sheet1 if the dates are mentioned in sheet2.
    I attached 2 screenshots to show what I mean.
    Sorry, my English is not good.

    sheet1.PNG

    sheet2.PNG

    Please help.
    Thank you.

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Need help with conditional formatting with Vlookup

    Make column A of sheet 2 proper dates then in A3 enter the CF

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    and copy this down to row 8 and across for the whole of the month.

    Repeat for the other blocks of months.

    Also consider making the row 2 dates dynamic and using a start date cell and end date cell to define what the columns of dates should be. This would avoid the need to have separate blocks of months if you are really just interested in looking at a specific period range.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Contributor mikehk's Avatar
    Join Date
    09-05-2017
    Location
    Hong Kong
    MS-Off Ver
    Office 365
    Posts
    483

    Re: Need help with conditional formatting with Vlookup

    Got it....


    thank you sooooooo much!

+ 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. Use VLOOKUP and conditional formatting?
    By Bow To The Robots in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-17-2017, 12:48 PM
  2. [SOLVED] Conditional Formatting with OR and VLOOKUP
    By AdamDShearer in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-30-2016, 05:34 PM
  3. [SOLVED] Conditional Formatting using VLOOKUP
    By Knawl in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-07-2014, 12:46 PM
  4. A mix between conditional formatting and vlookup
    By m4ckg in forum Excel General
    Replies: 1
    Last Post: 06-10-2011, 11:16 AM
  5. Vlookup/conditional formatting
    By david_pt in forum Excel General
    Replies: 2
    Last Post: 12-11-2009, 08:47 PM
  6. Using conditional formatting with vlookup
    By benno87 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-27-2008, 09:49 PM
  7. conditional formatting and VLookup
    By KatherineMolina in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-04-2006, 03:20 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