Re: $$Excel-Macros$$ Help Required on Conditional Formating

2015-03-07 Thread Mukesh Gupta
Thanks On 7 Mar 2015 14:46, "Vaibhav Joshi" wrote: > Hi > > check this.. www.excelzoom.com/how-to-create-a-calendar-in-excel/ > > Cheers!! > > On Fri, Mar 6, 2015 at 8:02 AM, Mukesh Gupta > wrote: > >> Dear Friedns, >> >> Kindly help me

$$Excel-Macros$$ Help Required on Conditional Formating

2015-03-05 Thread Mukesh Gupta
Dear Friedns, Kindly help me in creating a conditional formating calander just like goole calander. My basis needs are as follows:- 1. Start Date 2. End Date 3. Days of Week( Could be Sunday to Monday any) 4. Start time of Class 5. End time of Class This could be for many teachers. Depending

Re: $$Excel-Macros$$ Vlookup against the value generated from formula

2011-08-18 Thread Mukesh Gupta
Dear Subhash, You need to use trim command on group code in both sheets...your problem will be resolved. ...Still if you are not able to handle do revert. Regards Mukesh Gupta On Mon, Jul 25, 2011 at 6:37 PM, Subhash Yadav wrote: > When

Re: $$Excel-Macros$$ Subtract the minimum value based on multiple criteria

2011-08-05 Thread Mukesh Gupta
Dear Friend, You just need to use the following formula A B C D CityCarrier Total Diff Albertville A 700.00 In the D field type =C3-$C$3 and just copy and paste this to remaining below in the Diff field. Do revert for further clarification. Regards Mukesh Gupta On