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?
|