Hi Kassie,

MWH wants to dsiplay the arrow in the same cell as the result

Thank you for this clarification

In fact Mark made this clear in subsequent post in a separate thread (see
the "Thanks" thread.

In the other thread, mark said:

I don't want to use a separate cell for the arrow, as I'll
have many columns of data over a long period of time.

I therefore suggested that Mark consider changing the sheet logic to
transpose rows and columns.

---
Regards,
Norman



"Kassie" wrote in message
...
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 A1A2, 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" wrote in message
...
One more question if A2 = A1, i don't want an arrow to show, right now
I
always get a down arrow


"Norman Jones" wrote in message
...
Hi MWH,

Try the following two-pronged approach:

(1) In B2: =If(A2A1, "p","q") Format with Windings3 font.

(2) Set conditional formats for the three possible cases:


=A1A2 | Font: Bold Red
=A1<A2 | Font: Bold Green
=A1 =A2 | Font: Normal White


---
Regards,
Norman



"MWH" wrote in message
...
If cell A2 A1 I would like to show an up arrow next to the value,
and
visa versa...

--
Mark W. Hanford