View Single Post
 
Old 09-18-2017, 02:12 AM
mikehk mikehk is offline Windows 10 Office 2013
Novice
 
Join Date: Sep 2017
Posts: 15
mikehk is on a distinguished road
Default How to highlight cells using Vlookup / conditional formatting

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.
Attached Files
File Type: xlsx cal_cf.xlsx (11.8 KB, 9 views)
Reply With Quote