Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
#5
|
|||
|
|||
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? |
#6
|
|||
|
|||
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? |
#7
|
|||
|
|||
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? |
#8
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Color a cell and a value is automatically assigned to that color. | Excel Worksheet Functions | |||
Excel to allow color setting for autofilter drop-down arrow | Excel Discussion (Misc queries) | |||
Change rollover color on autofilter arrow from blue to red | Excel Worksheet Functions | |||
Identifying the Active Fill Color | Excel Discussion (Misc queries) | |||
How do I change the color of the drop down arrow when using the a. | Excel Discussion (Misc queries) |