from:"Ahmed Emam"

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 <aaa222e...@gmail.com> wrote:

>
>
> On Sun, Jan 10, 2016 at 4:03 PM, Abhishek Jain <abhishek@gmail.com>
> wrote:
>
>> Hi
>>
>> Plz share a sample workbook.
>>
>>
>>
>> On Sunday, January 10, 2016, Ahmed Emam <aaa222e...@gmail.com> wrote:
>>
>>> 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.
>>>
>>> Thanks in advance.
>>>
>>> --
>>> 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 Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at https://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>> --
>> 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 Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at https://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

-- 
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 Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

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 below? Dates should be concatenated ? check the attachment
> result sheet
>
> Code  Result/Absent on
> 38 4thDec/11th Dec
> 394Dec/11th Dec
> 183   4th --- 28th Dec
>
> Regards,
> Mandeep baluja
>
> --
> 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 Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$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.

Thanks in advance.

-- 
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 Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

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

2014-07-20 Thread Ahmed Emam

Thanks


On Sun, Jul 20, 2014 at 10:06 AM, Vaibhav Joshi v...@vabs.in wrote:

 Just copy the cell in which you have applied conditional formatting, after
 that select cells where you need to apply same formatting, then Paste
 special formatting to it by right clicking on selected cells.

 Check this attachment.

 Cheers!!


 On Sun, Jul 20, 2014 at 2:51 AM, Ahmed Emam aaa222e...@gmail.com 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 attached file.
 Now i want to apply it to the cell range from C3 to N3 and  C22 to N22.

 Brief:

 the formula to apply on every row from C to N Based on three other cells
 in O,P  Q.


 On Fri, Jul 18, 2014 at 2:30 PM, Vaibhav Joshi v...@vabs.in wrote:

 Cheers. .
 On Jul 18, 2014 4:50 PM, Ahmed Emam aaa222e...@gmail.com wrote:

 Thanks for your support


 On Fri, Jul 18, 2014 at 9:40 AM, Vaibhav Joshi v...@vabs.in 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, Ahmed Emam aaa222e...@gmail.com
 wrote:

 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 v...@vabs.in wrote:

 Check this!!

 Cheers!


 On Wed, Jul 16, 2014 at 8:47 PM, Ahmed Emam aaa222e...@gmail.com
 wrote:

 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 Green if Cell C1 filled by text

 --
 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 Facebook page of this 
 forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like
 Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
 Advice will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any
 security measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum
 owners and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it,
 send an email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.


  --
 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 Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like
 Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
 Advice will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners
 and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it,
 send an email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.


  --
 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 Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like
 Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
 Advice will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed

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

2014-07-19 Thread Ahmed Emam

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 attached file.
Now i want to apply it to the cell range from C3 to N3 and  C22 to N22.

Brief:

the formula to apply on every row from C to N Based on three other cells in
O,P  Q.


On Fri, Jul 18, 2014 at 2:30 PM, Vaibhav Joshi v...@vabs.in wrote:

 Cheers. .
 On Jul 18, 2014 4:50 PM, Ahmed Emam aaa222e...@gmail.com wrote:

 Thanks for your support


 On Fri, Jul 18, 2014 at 9:40 AM, Vaibhav Joshi v...@vabs.in 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, Ahmed Emam aaa222e...@gmail.com
 wrote:

 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 v...@vabs.in wrote:

 Check this!!

 Cheers!


 On Wed, Jul 16, 2014 at 8:47 PM, Ahmed Emam aaa222e...@gmail.com
 wrote:

 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 Green if Cell C1 filled by text

 --
 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 Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like
 Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
 Advice will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners
 and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it,
 send an email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.


  --
 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 Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like
 Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
 Advice will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners
 and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send
 an email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.


  --
 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 Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners
 and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send
 an email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros

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 v...@vabs.in 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, Ahmed Emam aaa222e...@gmail.com wrote:

 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 v...@vabs.in wrote:

 Check this!!

 Cheers!


 On Wed, Jul 16, 2014 at 8:47 PM, Ahmed Emam aaa222e...@gmail.com
 wrote:

 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 Green if Cell C1 filled by text

 --
 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 Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners
 and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send
 an email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.


  --
 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 Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send
 an email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.


  --
 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 Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.


  --
 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 Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need

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 v...@vabs.in wrote:

 Check this!!

 Cheers!


 On Wed, Jul 16, 2014 at 8:47 PM, Ahmed Emam aaa222e...@gmail.com wrote:

 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 Green if Cell C1 filled by text

 --
 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 Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.


  --
 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 Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.


-- 
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 Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$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 Green if Cell C1 filled by text

-- 
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 Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


111.xlsx
Description: MS-Excel 2007 spreadsheet

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 chilexcel...@gmail.com wrote:

 Please see attachment

 Chilexcel


 2011/10/4 Ahmed Emam aaa222e...@gmail.com

 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*
 Imam Muslim St., Dirab Road,Al Shifa.Saudi Arabia
 P.O. Box 331240 Riyadh 11373

 Tel   : +966-1- 423 9742
 Fax : +966-1- 423 9734
 Mobile  : +966-530722135

 E-mail   : audi...@alamana-tech.com
 www.alamana-tech.com



 --

 --
 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




 --
 Visita ; http://sites.google.com/site/chilexcel/Home
 Visita ; http://www.youtube.com/user/timextag41

  --

 --
 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




-- 

===*
*

*Ahmed Abu Al magd** Al emam***
General Accountant
*Al-Amana Technology Est. for Contracting*
Imam Muslim St., Dirab Road,Al Shifa.Saudi Arabia
P.O. Box 331240 Riyadh 11373

Tel   : +966-1- 423 9742
Fax : +966-1- 423 9734
Mobile  : +966-530722135

E-mail   : audi...@alamana-tech.com
www.alamana-tech.com

-- 
--
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

$$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*
Imam Muslim St., Dirab Road,Al Shifa.Saudi Arabia
P.O. Box 331240 Riyadh 11373

Tel   : +966-1- 423 9742
Fax : +966-1- 423 9734
Mobile  : +966-530722135

E-mail   : audi...@alamana-tech.com
www.alamana-tech.com

-- 
--
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

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

2011-10-04 Thread Ahmed Emam

the file i need will have a list and every item will has in the next column
a check box that when i finish with one item i can check it.
As i told before it will be a to-do list.
Thanks

On Tue, Oct 4, 2011 at 7:18 PM, rajan verma rajanverma1...@gmail.comwrote:

 hi,
 please explain ..

 On Tue, Oct 4, 2011 at 11:38 AM, Ahmed Emam aaa222e...@gmail.com 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

 --

 ===*
 *

 *Ahmed Abu Al magd** Al emam***
 General Accountant
 *Al-Amana Technology Est. for Contracting*
 Imam Muslim St., Dirab Road,Al Shifa.Saudi Arabia
 P.O. Box 331240 Riyadh 11373

 Tel   : +966-1- 423 9742
 Fax : +966-1- 423 9734
 Mobile  : +966-530722135

 E-mail   : audi...@alamana-tech.com
 www.alamana-tech.com



 --

 --
 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




 --
 Regards
 Rajan verma
 +91 9158998701

 --

 --
 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




-- 

===*
*

*Ahmed Abu Al magd** Al emam***
General Accountant
*Al-Amana Technology Est. for Contracting*
Imam Muslim St., Dirab Road,Al Shifa.Saudi Arabia
P.O. Box 331240 Riyadh 11373

Tel   : +966-1- 423 9742
Fax : +966-1- 423 9734
Mobile  : +966-530722135

E-mail   : audi...@alamana-tech.com
www.alamana-tech.com

-- 
--
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

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 noorain.ans...@gmail.comwrote:

 Dear Ahmed,

 if possible, Can you share Sample sheet with group..

 On Tue, Oct 4, 2011 at 11:38 AM, Ahmed Emam aaa222e...@gmail.com 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

 --

 ===*
 *

 *Ahmed Abu Al magd** Al emam***
 General Accountant
 *Al-Amana Technology Est. for Contracting*
 Imam Muslim St., Dirab Road,Al Shifa.Saudi Arabia
 P.O. Box 331240 Riyadh 11373

 Tel   : +966-1- 423 9742
 Fax : +966-1- 423 9734
 Mobile  : +966-530722135

 E-mail   : audi...@alamana-tech.com
 www.alamana-tech.com



 --

 --
 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




 --
 Thanks  regards,
 Noorain Ansari
  *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
 *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/

  --

 --
 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




-- 

===*
*

*Ahmed Abu Al magd** Al emam***
General Accountant
*Al-Amana Technology Est. for Contracting*
Imam Muslim St., Dirab Road,Al Shifa.Saudi Arabia
P.O. Box 331240 Riyadh 11373

Tel   : +966-1- 423 9742
Fax : +966-1- 423 9734
Mobile  : +966-530722135

E-mail   : audi...@alamana-tech.com
www.alamana-tech.com

-- 
--
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


New Работен лист на Microsoft Excel.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

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 dguille...@gmail.com wrote:

   Can you simply use
 datavalidation
  as shown in the attached
  *From:* Ahmed Emam aaa222e...@gmail.com
 *Sent:* Tuesday, October 04, 2011 1:16 PM
 *To:* excel-macros@googlegroups.com
 *Subject:* Re: $$Excel-Macros$$ I need help

  Here it's attached

 On Tue, Oct 4, 2011 at 8:39 PM, NOORAIN ANSARI 
 noorain.ans...@gmail.comwrote:

 Dear Ahmed,

 if possible, Can you share Sample sheet with group..

  On Tue, Oct 4, 2011 at 11:38 AM, Ahmed Emam aaa222e...@gmail.comwrote:

 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*
 Imam Muslim St., Dirab Road,Al Shifa.Saudi Arabia
 P.O. Box 331240 Riyadh 11373

 Tel   : +966-1- 423 9742
 Fax : +966-1- 423 9734 %2B966-1-%20423%209734
 Mobile  : +966-530722135

 E-mail   : audi...@alamana-tech.com
 www.alamana-tech.com



 --

 --
 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




 --
 Thanks  regards,
 Noorain Ansari
  *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
 *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/

 --

 --
 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




 --

 ===*
 *

 *Ahmed Abu Al magd** Al emam***
 General Accountant
 *Al-Amana Technology Est. for Contracting*
 Imam Muslim St., Dirab Road,Al Shifa.Saudi Arabia
 P.O. Box 331240 Riyadh 11373

 Tel   : +966-1- 423 9742
 Fax : +966-1- 423 9734
 Mobile  : +966-530722135

 E-mail   : audi...@alamana-tech.com
 www.alamana-tech.com



 --

 --
 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

 --

 --
 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




-- 

===*
*

*Ahmed Abu Al magd** Al emam***
General Accountant
*Al-Amana Technology Est. for Contracting*
Imam Muslim St., Dirab Road,Al Shifa.Saudi Arabia
P.O. Box 331240 Riyadh 11373

Tel   : +966-1- 423 9742
Fax : +966-1- 423 9734
Mobile  : +966-530722135

E-mail   : audi...@alamana-tech.com
www.alamana-tech.com

-- 
--
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

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

2009-11-26 Thread Ahmed Emam

Dear Andy,

I got your reply but you want me to write the date at first in Gregorian
format then the system will convert it?
If so it will be difficult somehow because it's already in Hijri format and
i just want it to be highlighted before a month as i told u before.
The other problem that i don't want to convert the windows system because it
already can recognize it.
Another thing, how can i add the mentioned registry key.

Thanks
A.A..A.

On Thu, Nov 26, 2009 at 3:07 PM, Aindril De aind...@gmail.com wrote:

 Dear Ahmed,

 We have to get to this solution Step by Step:

 1) Convert Windows and Excel to recognize Hijri Date.
 2) Resolve your query on the expiry date.

 1) To use the Hijri date format in Windows and subsequently in Excel, you
 need to follow the following steps:

 The following steps show how we can custom the date in the cells, to be
 entered as Gregorian format and interpreted in Hijri format, also we will
 describe how we can enter a date in Hijri format in a cell.

 *Type a date in Gregorian format and have Excel interpret it as Hijri date
 *:

1. On the Format menu, click Cells, and then click the Number tab.
2. From the Type list select the Hijri format that you want to use and
press OK, or continue to proceed in the next steps (Step 3)
3. Select Custom from the list of categories.
4. In the Type box, do one of the following:
   1. B1dd/mm/yy - To display dates using the Gregorian calendar,
   regardless of the Regional Options or Regional Settings of the Microsoft
   Windows Control Panel setting, type B1 before the date format.
   2. B2dd/mm/yy – to type the date in Gregorian format but it will be
   interpreted and displayed as Hijri date.

 This means that Arabic editing is enabled, to display dates using the Hijri
 calendar and regardless of the Regional Options or Regional Settings
 setting, type B2 before the date format code. Note It is also possible to
 format the date by changing the locale selected in the Locale (location) box
 for the Date category on the Number tab and then selecting a date format in
 the Type box.

 *Type a date in a cell in Hijri format.*
 The following method will work only on Arabic Office SKU.
 To enable this method for non Arabic SKU’s; you will need to add the
 following registry key: HKCU\Software\Microsoft\Office\11.0\Excel\Options\
 Value = xl9_hijri
 Value Type = DWORD
 Value Data = 0


 To enter Hijri date, type A or a in front of the date entry
 For example, you can enter the short date 'a9/25/20', which will be
 interpreted as Hijri date 9/25/1420 (this is Gregorian date 1/1/2000). If
 the cell is unformatted, it will be assigned the number format 'B2m/d/'
 and the value will be displayed as '9/25/1420' Note Your regional settings
 affect how Excel recognizes the day, month and year parts of the value
 entered. For example, when using English (United States) regional settings,
 you should enter the Hijri value as 'a9/25/20'. When using Arabic (Egypt)
 regional settings, you should enter 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 before you move to the resolution
 number 2.

 Regards,
 Andy

 On Thu, Nov 26, 2009 at 3:25 PM, Ahmed Emam aaa222e...@gmail.com wrote:

 Hi Gurus ,

 I need a conditional formatting for this excel sheet which is supposed to
 give me warning for expiry
 date of residential permit , but my problem is my windows date  time is
 Gregorian  this dates are
 in Hijri format.
 I need it to warn me a month before expiry date .
 Can anyone help me here ?

 Thanks  Best Regards
 --
 A.A.A.

 --

 --
 Some important links for excel users:
 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
 http://www.excelitems.com
 2. Excel tutorials at http://www.excel-macros.blogspot.com
 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com


 To post to this group, send email to excel-macros@googlegroups.com
 If you find any spam message in the group, please send an email to:
 Ayush Jain @ jainayus...@gmail.com or
 Ashish Jain @ 26may.1...@gmail.com
 
 HELP US GROW !!

 We reach over 6,500 subscribers worldwide and receive many nice notes
 about the learning and support from the group. Our goal is to have 10,000
 subscribers by the end of 2009. Let friends and co-workers know they can
 subscribe to group at
 http://groups.google.com/group/excel-macros/subscribe


  --

 --
 Some important links for excel users:
 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
 http://www.excelitems.com
 2. Excel tutorials at http://www.excel

$$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.

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

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

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

$$Excel-Macros$$ Required Missing Date

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

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

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

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

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

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

$$Excel-Macros$$ I need help

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

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

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

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

$$Excel-Macros$$ Need for Conditional Formatting

15 matches

Site Navigation

Mail list logo

Footer information