Re: Up Arrows / Down Arrows

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Norman

MWH wants to dsiplay the arrow in the same cell as the result, hence the
question about concatenation. This would mean that his values are turned
into text of course. Using the ampersand "&" you can concatenate the two
results of the two formulae. the question is whether you still want to be
able to do calculations on this cell afterwards.

"Norman Jones" wrote:

> Hi MWH,
>
> Just to add, using both of the approaches indicated in my initial reply, the
> arrows would appear red, green or invisible (white on white background)
> acoccording to A1>A2, A1<A2 or A1=A2.
>
> If , therefore, you include the conditional format element, you do not need
> to use the revised formula.
>
> ---
> Regards,
> Norman
>
>
>
> "MWH" <mhanfor1@xxxxxxxxxxx> wrote in message
> news:LWwxe.93589$g5.42227@xxxxxxxxxxxxxxxxxxxxxxx
> > One more question if A2 = A1, i don't want an arrow to show, right now I
> > always get a down arrow
> >
> >
> > "Norman Jones" <normanjones@xxxxxxxxxxxxxxxxxxx> wrote in message
> > news:ul3b3NrfFHA.1148@xxxxxxxxxxxxxxxxxxxxxxx
> >> Hi MWH,
> >>
> >> Try the following two-pronged approach:
> >>
> >> (1) In B2: =If(A2>A1, "p","q") Format with Windings3 font.
> >>
> >> (2) Set conditional formats for the three possible cases:
> >>
> >>
> >> =A1>A2 | Font: Bold Red
> >> =A1<A2 | Font: Bold Green
> >> =A1 =A2 | Font: Normal White
> >>
> >>
> >> ---
> >> Regards,
> >> Norman
> >>
> >>
> >>
> >> "MWH" <mhanfor1@xxxxxxxxxxx> wrote in message
> >> news:2Bmxe.93548$g5.82994@xxxxxxxxxxxxxxxxxxxxxxx
> >>> If cell A2 > A1 I would like to show an up arrow next to the value, and
> >>> visa versa...
> >>>
> >>> --
> >>> Mark W. Hanford
> >>> mhanfor1@xxxxxxxxxxxx
> >>>
> >>
> >>
> >
> >
>
>
>
.

Relevant Pages

  • Re: Up Arrows / Down Arrows
    ... In fact Mark made this clear in subsequent post in a separate thread (see ... > I don't want to use a separate cell for the arrow, ... > MWH wants to dsiplay the arrow in the same cell as the result, ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Norman Re: Up Arrows / Down Arrows
    ... > what does the value SUMhave to exceed for the up arrow ... >> combine the formula so the cell that contains the value and will show the ... >>> Hi MWH, ... >>> Norman ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Getting to first blank row from middle of long list?
    ... All blanks will be highlighted with the first one ... direction to the last contiguous cell with data in it. ... arrow> this will take you to the bottom cell of contiguous data (i.e. ...
    (microsoft.public.excel.misc)
  • Re: Validation, Conditional Formatting and Font Types
    ... They're part of the IBM PC Extended Character Set. ... Risky Dave wrote: ... In the cell below, type Alt+26 ... What I want the cell to display is an arrow representing the value selected in the drop down. ...
    (microsoft.public.excel)
  • Re: Validation, Conditional Formatting and Font Types
    ... What is this character set (I'm onnly familiar with ASCII and it doesn't ... In the cell below, type Alt+26 ... Select the cells where you want the validation ... What I want the cell to display is an arrow representing the value selected ...
    (microsoft.public.excel)