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