How to highlight cells using Vlookup / conditional formatting

mikehk · #1 09-18-2017, 02:12 AM

I have a quarterly calendar (sample file attached)
Sheet1 has dates in rows, I would like to highlight some columns in
Sheet1 if the dates are in Sheet2 (it could be holidays, exhibition, etc).

Please help.

Thank you.

xor · #2 09-18-2017, 03:49 AM

Take a look at the attached.

mikehk · #3 09-18-2017, 07:30 PM

Thank you so much!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional formatting to color cells based on number	kallard	Excel	4	12-26-2016 11:10 AM
Conditional formating all cells in an array based on adjacent cells	deejay	Excel	6	12-20-2016 12:00 PM
Conditional Formatting for Cells Containing Formula	Gillian623	Excel	1	12-09-2016 11:03 PM
Disappearing Cells Issue (Possibly Related to Conditional Formatting)	sk8blitz23	Excel	6	03-02-2016 03:06 PM
Conditional Formatting- Only format cells once data is entered	chart3	Excel Programming	1	12-15-2015 11:26 AM