IF CONDITION & Arrow instead of color
 

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?

Just change your formula to

=IF(YourCondition,CHAR(173),CHAR(175)) and FormatCellsFont, Symbol

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Polina" wrote in message
...
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?

no i am still confused, please explain its like if cell a23a24 i want up
arrow, if less i want down arrow

"Niek Otten" wrote:

Just change your formula to

=IF(YourCondition,CHAR(173),CHAR(175)) and FormatCellsFont, Symbol

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Polina" wrote in message
...
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?

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

"Niek Otten" wrote:

Just change your formula to

=IF(YourCondition,CHAR(173),CHAR(175)) and FormatCellsFont, Symbol

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Polina" wrote in message
...
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?

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)


"Polina" wrote in message
...
no i am still confused, please explain its like if cell a23a24 i want up
arrow, if less i want down arrow

"Niek Otten" wrote:

Just change your formula to

=IF(YourCondition,CHAR(173),CHAR(175)) and FormatCellsFont, Symbol

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Polina" wrote in message
...
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?

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

"Polina" wrote in message
...
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

"Niek Otten" wrote:

Just change your formula to

=IF(YourCondition,CHAR(173),CHAR(175)) and FormatCellsFont, Symbol

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Polina" wrote in message
...
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?

THANKS SOOO VERY MUCH AGAIN

"Niek Otten" wrote:

Just change your formula to

=IF(YourCondition,CHAR(173),CHAR(175)) and FormatCellsFont, Symbol

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Polina" wrote in message
...
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?

Niek

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


Gord Dibben Excel MVP

On Wed, 4 May 2005 22:07:14 +0200, "Niek Otten" wrote:

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.