Hi MWH,
Try Changing:
=If(A2>A1, "p","q")
To
=IF(A1=A2,"",IF(A2>A1, "p","q")
--
---
Regards,
Norman
"MWH" <[email protected]> wrote in message
news:[email protected]...
> One more question if A2 = A1, i don't want an arrow to show, right now I
> always get a down arrow
>
>
> "Norman Jones" <[email protected]> wrote in message
> news:[email protected]...
>> 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" <[email protected]> wrote in message
>> news:[email protected]...
>>> If cell A2 > A1 I would like to show an up arrow next to the value, and
>>> visa versa...
>>>
>>> --
>>> Mark W. Hanford
>>> [email protected]
>>>
>>
>>
>
>
Bookmarks