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!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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