Oops, forgot to write Holiday*s*
=ISNUMBER(MATCH(INDIRECT("RC",FALSE),Holiday*s*,0))
Sam
On Thu, Oct 13, 2011 at 11:55 AM, Sam Mathai Chacko wrote:
> Use this formula based conditional in your Sheet 2 column A
>
> =ISNUMBER(MATCH(INDIRECT("RC",FALSE),Holidays,0))
>
> Regards,
>
> Sam Mathai Cha
Use this formula based conditional in your Sheet 2 column A
=ISNUMBER(MATCH(INDIRECT("RC",FALSE),Holiday,0))
Regards,
Sam Mathai Chacko
On Thu, Oct 13, 2011 at 6:09 AM, Atul wrote:
> Hi,
> I need your help on using conditional formatting for a cell contaning
> date.worksheet1 has range A1:b10
Hi,
I need your help on using conditional formatting for a cell contaning
date.worksheet1 has range A1:b10 which contains name of holiday in col
A and dates in col B. Range b1:b10 is defined name as 'Holidays'.
Worksheet2 contains dates in col A where I want to insert specific
colour using conditio
