Re: Fwd: $$Excel-Macros$$ Formula to highlight planned leave by Conditional formating

2013-08-28 Thread Zibraan
;> Lucky S >> >> >> On Wed, Aug 28, 2013 at 3:37 PM, ravinder negi wrote: >> >>> pls advise where you want answer and what exactly. >>> >>> -------------- >>> *From:* Zibraan >>> *To:* excel-macros@googlegr

Re: Fwd: $$Excel-Macros$$ Formula to highlight planned leave by Conditional formating

2013-08-28 Thread Zibraan
*From:* Zibraan > *To:* excel-macros@googlegroups.com > *Sent:* Wednesday, August 28, 2013 11:41 AM > *Subject:* Fwd: $$Excel-Macros$$ Formula to highlight planned leave by > Conditional formating > > > Hi Team, > > Awaited for your expertise advice. > &g

Re: Fwd: $$Excel-Macros$$ Formula to highlight planned leave by Conditional formating

2013-08-28 Thread ravinder negi
pls advise where you want answer and what exactly. From: Zibraan To: excel-macros@googlegroups.com Sent: Wednesday, August 28, 2013 11:41 AM Subject: Fwd: $$Excel-Macros$$ Formula to highlight planned leave by Conditional formating Hi Team, Awaited for

Fwd: $$Excel-Macros$$ Formula to highlight planned leave by Conditional formating

2013-08-27 Thread Zibraan
Hi Team, Awaited for your expertise advice. Thanks & Regards, Lucky S -- Forwarded message -- From: Zibraan Date: Mon, Aug 26, 2013 at 7:36 PM Subject: $$Excel-Macros$$ Formula to highlight planned leave by Conditional formating To: excel-macros@googlegroups.com Hi

Re: $$Excel-Macros$$ Formula to highlight planned leave by Conditional formating

2013-08-26 Thread Zibraan
NO actually i want to show L whichever dates he have taken leave. But it should be automated by formula so that i just need to enter the dates in the sheet named "Database" and it will automatically highlights those dates in red in sheet "Summary" and the previous leave dates would be available wi

Re: $$Excel-Macros$$ Formula to highlight planned leave by Conditional formating

2013-08-26 Thread ashish koul
Do you want to show date rather than "L" sign? On Mon, Aug 26, 2013 at 7:36 PM, Zibraan wrote: > Hi Team, > > Please refer the Sheet in which I need a formula which can calculate and > show the planned leaves in date format and should highlight in Red. > > > Thanks & Regards, > Lucky > > -- > A

$$Excel-Macros$$ Formula to highlight planned leave by Conditional formating

2013-08-26 Thread Zibraan
Hi Team, Please refer the Sheet in which I need a formula which can calculate and show the planned leaves in date format and should highlight in Red. Thanks & Regards, Lucky -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebo