Re: $$Excel-Macros$$ Required Missing Date

2016-01-17 Thread Ahmed Emam
Dear All members Any update ? On Mon, Jan 11, 2016 at 10:07 AM, Ahmed Emam wrote: > > > On Sun, Jan 10, 2016 at 4:03 PM, Abhishek Jain > wrote: > >> Hi >> >> Plz share a sample workbook. >> >> >> >> On Sunday, January 10, 20

Re: $$Excel-Macros$$ Re: Required Missing Date

2016-01-12 Thread Ahmed Emam
The result is OK, but it would be better if the missing date being showed in its place between all dates during the month in the original sheet. On Mon, Jan 11, 2016 at 10:48 AM, Mandeep Baluja wrote: > Do you need a macro solution ? Do you wish to achieve and made your data > like this given be

$$Excel-Macros$$ Required Missing Date

2016-01-10 Thread Ahmed Emam
Dear All members, I have an excel sheet which being extracted from a fingerprints device that shows all dates employees had put their fingers already to prove their presence. My request is how to make equation that shows to me the other dates employees didn't put their fingerprints in the device.

Re: $$Excel-Macros$$ Conditional Formatting for a cell based on another

2014-07-20 Thread Ahmed Emam
> Check this attachment. > > Cheers!! > > > On Sun, Jul 20, 2014 at 2:51 AM, Ahmed Emam wrote: > >> I applied the formula as you did to one cell, but now i want to apply it >> to a whole table as attached. >> I applied it to Cell C3 to be based on O, P, Q in the a

Re: $$Excel-Macros$$ Conditional Formatting for a cell based on another

2014-07-19 Thread Ahmed Emam
Based on three other cells in O,P & Q. On Fri, Jul 18, 2014 at 2:30 PM, Vaibhav Joshi wrote: > Cheers. . > On Jul 18, 2014 4:50 PM, "Ahmed Emam" wrote: > >> Thanks for your support >> >> >> On Fri, Jul 18, 2014 at 9:40 AM, Vaibhav Joshi wrote: &g

Re: $$Excel-Macros$$ Conditional Formatting for a cell based on another

2014-07-18 Thread Ahmed Emam
Thanks for your support On Fri, Jul 18, 2014 at 9:40 AM, Vaibhav Joshi wrote: > Hi > > Check conditional format set in sheet.. > > First select Cell A1, then conditional formting and Manage Rules... > > Cheers!! > > > > > On Fri, Jul 18, 2014 at 12:51 AM,

Re: $$Excel-Macros$$ Conditional Formatting for a cell based on another

2014-07-17 Thread Ahmed Emam
That' what i mean but i need t know how to do it because i will apply it to other file thanks On Thu, Jul 17, 2014 at 10:03 AM, Vaibhav Joshi wrote: > Check this!! > > Cheers! > > > On Wed, Jul 16, 2014 at 8:47 PM, Ahmed Emam wrote: > >> I have an excel s

$$Excel-Macros$$ Conditional Formatting for a cell based on another

2014-07-16 Thread Ahmed Emam
I have an excel sheet and i want some cells to be highlighted by some colors if other 3 cells filled by text. please see the attached example: What i mean that Cell A to be highlighted Yellow if Cell A1 filled by text And to be highlighted Blue if Cell B1 filled by text And to be highlighted Gree

Re: $$Excel-Macros$$ I need help

2011-10-06 Thread Ahmed Emam
Thanks very much for your help, that's exactly what i need. Thanks again On Thu, Oct 6, 2011 at 3:56 AM, ChilExcel wrote: > Please see attachment > > Chilexcel > > > 2011/10/4 Ahmed Emam > >> Hi all members, >> >> I need an Excel sheet that contains

Re: $$Excel-Macros$$ I need help

2011-10-04 Thread Ahmed Emam
I'm sorry, but it's not like that I need it to be checked when i click on it like this symbol ( *√* ) On Tue, Oct 4, 2011 at 9:28 PM, dguillett1 wrote: > Can you simply use > data>validation > as shown in the attached > *From:* Ahmed Emam > *Sent:* Tuesday, Oc

Re: $$Excel-Macros$$ I need help

2011-10-04 Thread Ahmed Emam
Here it's attached On Tue, Oct 4, 2011 at 8:39 PM, NOORAIN ANSARI wrote: > Dear Ahmed, > > if possible, Can you share Sample sheet with group.. > > On Tue, Oct 4, 2011 at 11:38 AM, Ahmed Emam wrote: > >> Hi all members, >> >> I need an Excel sheet th

Re: $$Excel-Macros$$ I need help

2011-10-04 Thread Ahmed Emam
011 at 11:38 AM, Ahmed Emam wrote: > >> Hi all members, >> >> I need an Excel sheet that contains check list for about 20 items , and >> that will be as a to-do note. >> Can anyone help me? >> >> Thanks in advance >> >> -- >> >

$$Excel-Macros$$ I need help

2011-10-04 Thread Ahmed Emam
Hi all members, I need an Excel sheet that contains check list for about 20 items , and that will be as a to-do note. Can anyone help me? Thanks in advance -- ===* * *Ahmed Abu Al magd** Al emam*** General Accountant *Al-Amana Technology Est. for Contracting* I

Re: $$Excel-Macros$$ Help for Expiry Date with Hijri Date System

2009-11-26 Thread Ahmed Emam
er the Hijri value as 'a25/9/20' Additional > keywords > > For more details you can visit the following link: > > http://support.microsoft.com/kb/871138 > > Once the above is achieved, your query can be easily resolved. > > But first, lets complete the first thing b

$$Excel-Macros$$ Need for Conditional Formatting

2009-10-07 Thread Ahmed Emam
I need a formula for a conditional formatting to make a cell that contain a date comes from another sheet, if that date is less than (today+30 days) then it will change color . -- A.A.A. --~--~-~--~~~---~--~~ ---

$$Excel-Macros$$ Need for Conditional Formatting

2009-10-07 Thread Ahmed Emam
I need a formula for a conditional formatting to make a cell that contain a date comes from another sheet, if that date is less than (today+30 days) then it will change color but this date is hijri not Gregorian. -- A.A.A. --~--~-~--~~~---~--~~ ---