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?