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 <samde...@gmail.com>wrote: > Use this formula based conditional in your Sheet 2 column A > > =ISNUMBER(MATCH(INDIRECT("RC",FALSE),Holidays,0)) > > Regards, > > Sam Mathai Chacko > > > On Thu, Oct 13, 2011 at 6:09 AM, Atul <atul_pate...@yahoo.com> wrote: > >> 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 conditional format. For example cell a2 of sheet 2 >> contains the date which is also one of the holidays in range b1:b10 of >> sheet 1 , the cell a2 should be highlighted by say yellow color. >> Please help me on formula >> Thanks >> Atul >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > > > -- > Sam Mathai Chacko > -- Sam Mathai Chacko -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel