Conditional formatting using Vlookup

[Ram8516]

Hi,

I have two sheets one sheets ( date list) with meeting dates in A:A column and in another sheet ( meeting sheet) i have dates from c1 onward for one year. I need to fill the whole column based on the date in date list sheet.,

For example if in date list i have date 22nd October. i need to fill the complete column in meeting sheet with a particular color. I have attached a sample sheet.

I need a conditional format to auto fill the colors.

Thank you in advance
Regards,
Ram

[Glenn Kennedy]

You can use:

=ISNUMBER(MATCH(C$1,Date_List!$A:$A,0))

[Ram8516]

Thank you Glenn. worked perfectly