Need help with conditional formatting with Vlookup

[mikehk]

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.

[Richard Buttrey]

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

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.

[mikehk]

Got it....


thank you sooooooo much!