How to highlight cells using Vlookup / conditional formatting

		Microsoft Office Forums > Microsoft Excel > Excel
How to highlight cells using Vlookup / conditional formatting

FAQ

Thread Tools

Display Modes

09-18-2017, 02:12 AM

mikehk

Windows 10 How to highlight cells using Vlookup / conditional formatting

Office 2013

Novice

Join Date: Sep 2017

Posts: 15

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

cal_cf.xlsx (11.8 KB, 9 views)

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:17 AM.