Entering symbol into spreadsheet

Occasional Contributor

I am wanting to show a an 'up arrow' or 'down arrow' into a cell depending if one number is higher or lower than another two adjacent cells


4 Replies

Hi @Bob_Lac 


You would use the conditional format

Home tab --> click on Conditional format on the style group

best response confirmed by Bob_Lac (Occasional Contributor)



You would you simple if formula if it is just adding arrow,

I assume that your data in cells B6, D6, so you can copy the arrow symbols and use them in the formula

@Jihad Al-Jarady 


That was what I wanted. It is working perfectly, Thank you very much


You are welcome,