Re: $$Excel-Macros$$ Conditional formatting

2014-06-15 Thread N.Shivkumar
Exactly and thanks for your reply ​ N.SHIVKUMAR Mobile : +919422613567 Office : +912332301775 Alternate Email: shiv1...@yahoo.com On 16 June 2014 11:54, Ravinder wrote: > PFA, if you are looking for this. > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@google

Re: $$Excel-Macros$$ Conditional formatting

2014-06-15 Thread N.Shivkumar
Dear Vaibhavji If the achievement is > 100% it should green arrow up, if it is less than 90% it should show red arrow down and if between 90 and 100 it should show straight arrow.​ N.SHIVKUMAR Mobile : +919422613567 Office : +912332301775 Alternate Email: shiv1...@yahoo.com On 16 Jun

RE: $$Excel-Macros$$ Conditional formatting

2014-06-15 Thread Ravinder
PFA, if you are looking for this. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of N.Shivkumar Sent: Monday, June 16, 2014 11:13 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Conditional formatting Dear friends Can anybody throw s

Re: $$Excel-Macros$$ Conditional formatting

2014-06-15 Thread Vaibhav Joshi
whats issue? On Mon, Jun 16, 2014 at 11:12 AM, N.Shivkumar wrote: > Dear friends > > Can anybody throw some light and help me as to where I am going wrong in > conditional formatting! > > > > > > > > > > N.SHIVKUMAR > Mobile : +919422613567 > Office : +912332301775 > Alternate Email: shiv1...@

$$Excel-Macros$$ Conditional formatting

2014-06-15 Thread N.Shivkumar
Dear friends Can anybody throw some light and help me as to where I am going wrong in conditional formatting! N.SHIVKUMAR Mobile : +919422613567 Office : +912332301775 Alternate Email: shiv1...@yahoo.com -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIM

Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 12 updates in 7 topics

2014-06-15 Thread Cab Boose
Hi Having a problem with Google Groups. Using Chrome Win7 To send a new message it comes up with email to, Subject heading, tags to enter, but there is no message block! to type in a message. Is there something I am missing ! Charles Harris On Mon, Jun 16, 2014 at 11:23 AM, wrote: > Today

$$Excel-Macros$$ Event for dynamically add control in Excel VBA

2014-06-15 Thread Ondřej Říha
Hello, I would like to add sub for click event of dynamically add control button in user form for example in VBA for Excel. I found some examples on Internet but every finished with some error or didn't work. When I use for example this way: Application.VBE.CodePanes(1).CodeModule.InsertLine

Re: $$Excel-Macros$$ plz add me to the group thanks

2014-06-15 Thread ankur kochar
On Feb 13, 2014 12:49 AM, "sudhansu mohan" wrote: > > -- > 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 tit

$$Excel-Macros$$ Re: how to crack Excel VBA password

2014-06-15 Thread David Sands
Hiya, Can anyone please recover the VBA password(s) for this file, I have recovered the excel (2010 macro enabled workbook) workbook and worksheet passwords. https://drive.google.com/file/d/0Bw6W1WHEetl7LUZyWC13WWw5cUU/edit?usp=sharing I have tried a few freeware VBA password recovery programm

Re: $$Excel-Macros$$ Date Format Query

2014-06-15 Thread Vaibhav Joshi
Hi You can change display format by going to cell property & select custom and type dd.mm. If by doing so if date format does not change then select single column then press Data tab in Menu then press Next 2 times then select Date (DMY) and press finish button. Cheers!! On Thu, Jun 12, 20

Re: $$Excel-Macros$$ Re: Need help with making a macro revolving around finding certain numbers from a list

2014-06-15 Thread Vaibhav Joshi
Hi You need to use count if formula to get what you want..in range you need to specify both the column where probable value would be. Refer file in my previous post with yellow colored range. Cheers!! On Sun, Jun 15, 2014 at 12:02 PM, Noah Shalii wrote: > Sorry I'm an excel noob, I don't u