Fwd: $$Excel-Macros$$ Challanging queri

2013-07-15 Thread Pravin Gunjal
Hi DP I too applied the same condition (pl see the green background in same sheet), but the result shown is different. Regards Pravin Gunjal. -- Forwarded message -- From: De Premor Date: Mon, Jul 15, 2013 at 7:30 PM Subject: Re: $$Excel-Macros$$ Challanging queri To: excel

Re: $$Excel-Macros$$ Challanging queri

2013-07-15 Thread De Premor
PFA Pada 15/07/2013 17:34, priti verma menulis: Hi group , Please try to solve this. Queri based on conditional formating If b2 >a2 then up arrow and coluor should be green . if b2Are 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 Fac

Re: $$Excel-Macros$$ Challanging queri

2013-07-15 Thread priti verma
, Jul 15, 2013 at 5:28 PM > Subject: Re: $$Excel-Macros$$ Challanging queri > To: excel-macros@googlegroups.com > > > HI rupali , > good job > > > On Mon, Jul 15, 2013 at 4:43 AM, Rupali Joshi wrote: > > Hi priti, > > Please find the solution. > In this

Re: $$Excel-Macros$$ Challanging queri

2013-07-15 Thread devanand nayak
: > And what about if the value is same in both columns. > > -- Forwarded message -- > From: priti verma > Date: Mon, Jul 15, 2013 at 5:28 PM > Subject: Re: $$Excel-Macros$$ Challanging queri > To: excel-macros@googlegroups.com > > > HI rupali , > go

Re: Fwd: $$Excel-Macros$$ Challanging queri

2013-07-15 Thread devanand nayak
Hi every one pl tell me where can I learn excel Pravin Gunjal wrote: And what about if the value is same in both columns. -- Forwarded message -- From: priti verma Date: Mon, Jul 15, 2013 at 5:28 PM Subject: Re: $$Excel-Macros$$ Challanging queri To: excel-macros

Re: $$Excel-Macros$$ Challanging queri

2013-07-15 Thread priti verma
M > Subject: Re: $$Excel-Macros$$ Challanging queri > To: excel-macros@googlegroups.com > > > HI rupali , > good job > > > On Mon, Jul 15, 2013 at 4:43 AM, Rupali Joshi wrote: > >> Hi priti, >> >> Please find the solution. >> In this first selec

Fwd: $$Excel-Macros$$ Challanging queri

2013-07-15 Thread Pravin Gunjal
And what about if the value is same in both columns. -- Forwarded message -- From: priti verma Date: Mon, Jul 15, 2013 at 5:28 PM Subject: Re: $$Excel-Macros$$ Challanging queri To: excel-macros@googlegroups.com HI rupali , good job On Mon, Jul 15, 2013 at 4:43 AM, Rupali

Re: $$Excel-Macros$$ Challanging queri

2013-07-15 Thread priti verma
HI rupali , good job On Mon, Jul 15, 2013 at 4:43 AM, Rupali Joshi wrote: > Hi priti, > > Please find the solution. > In this first select home--> symbol--> font(Arial)-->Up and down arrows , > then select the range where you have to put the formula using conditional > formatting & use formula

Re: $$Excel-Macros$$ Challanging queri

2013-07-15 Thread Rupali Joshi
Hi priti, Please find the solution. In this first select home--> symbol--> font(Arial)-->Up and down arrows , then select the range where you have to put the formula using conditional formatting & use formula "=B2>A2" then format--->Number>custom to set colour and arrow. Regards, Rupali Josh

Re: $$Excel-Macros$$ Challanging queri

2013-07-15 Thread Ahmed Honest
​Dear Priti, Please find attach the solution. It is too simple On Mon, Jul 15, 2013 at 1:34 PM, priti verma wrote: > Hi group , > > Please try to solve this. > > Queri based on conditional formating > > If b2 >a2 then up arrow and coluor should be green . > > if b2 > See PFA For more cl

$$Excel-Macros$$ Challanging queri

2013-07-15 Thread priti verma
Hi group , Please try to solve this. Queri based on conditional formating If b2 >a2 then up arrow and coluor should be green . if b2https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Pro