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