IF CONDITION & Arrow instead of color

P

Polina

If I have created conditional formatting is there any way to instead having
it turn a color have it instead let an arrow up or down appear?
 
N

Niek Otten

Just change your formula to

=IF(YourCondition,CHAR(173),CHAR(175)) and Format>Cells>Font, Symbol

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
P

Polina

no i am still confused, please explain its like if cell a23>a24 i want up
arrow, if less i want down arrow
 
P

Polina

Sorry I tried again and it worked, but where can i get a list of the
character number like what is smile what is down, is there a list.

Also thanks so very much for the help
 
B

Bob Phillips

I think that Nick is suggesting you don't use conditional formatting.

If you put his formula in an adjacent cell, you get your arrow alongside.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
N

Niek Otten

In A1, enter 0 (zero)
In A2, enter =A1+1
Fill down 255 cells.
In B1, enter =CHAR(A1)
Fill down by double-clicking the tiny square in the right-hand bottom corner
of the cell.
Format as Symbol.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
P

Polina

THANKS SOOO VERY MUCH AGAIN

Niek Otten said:
Just change your formula to

=IF(YourCondition,CHAR(173),CHAR(175)) and Format>Cells>Font, Symbol

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
G

Gord Dibben

Niek

In A1 enter =CHAR(ROW()) and drag down works well.


Gord Dibben Excel MVP
 
Top