Re: $$Excel-Macros$$ How to give the conditional formatting for the full data

2012-10-04 Thread Swapnil Palande
Yes, Actually I apply conditional formating for A2 and then copy it to all cells... thats y date formatting get change.. On Thu, Oct 4, 2012 at 4:19 PM, Pravin Gunjal wrote: > *Thanks Ahmed & Swapnil* > * > * > *Yes there was some date formatting went wrong in Swapnil's file.* > * > * > *Ahmed

Re: $$Excel-Macros$$ How to give the conditional formatting for the full data

2012-10-04 Thread Pravin Gunjal
*Thanks Ahmed & Swapnil* * * *Yes there was some date formatting went wrong in Swapnil's file.* * * *Ahmed : your file is absolutely fine. * * * *Thanks a lot !* * * *Pravin Gunjal* On Thu, Oct 4, 2012 at 4:08 PM, Ahmed Honest wrote: > Dear Pravin, > > PFA with Revised and Swapnil one solutio

Re: $$Excel-Macros$$ How to give the conditional formatting for the full data

2012-10-04 Thread Ahmed Honest
Dear Pravin, PFA with Revised and Swapnil one solution is also the same but it is disturbing the Date Column which has been undisturbed in my file. Choose which ever suits your requirement. Thanks, On Thu, Oct 4, 2012 at 1:15 PM, Ahmed Honest wrote: > Dear Pravin. > > *PFA* > > On Thu, Oct 4,

Re: $$Excel-Macros$$ How to give the conditional formatting for the full data

2012-10-04 Thread Swapnil Palande
Hi Pravin, PFA solution excel. Regards, Swapnil. On Thu, Oct 4, 2012 at 3:31 PM, Pravin Gunjal wrote: > *Hello Friends,* > * > * > *I require a help on the subject matter. The file is attached for your > reference.* > * > * > *I have used the conditional formatting as mentioned in the excel

Re: $$Excel-Macros$$ How to give the conditional formatting for the full data

2012-10-04 Thread Ahmed Honest
Dear Pravin. *PFA* On Thu, Oct 4, 2012 at 1:01 PM, Pravin Gunjal wrote: > *Hello Friends,* > * > * > *I require a help on the subject matter. The file is attached for your > reference.* > * > * > *I have used the conditional formatting as mentioned in the excel file. > And I required that the