SOLVED

Entering symbol into spreadsheet

%3CLINGO-SUB%20id%3D%22lingo-sub-2036995%22%20slang%3D%22en-US%22%3EEntering%20symbol%20into%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2036995%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20wanting%20to%20show%20a%20an%20'up%20arrow'%20or%20'down%20arrow'%20into%20a%20cell%20depending%20if%20one%20number%20is%20higher%20or%20lower%20than%20another%20two%20adjacent%20cells%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2036995%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2037034%22%20slang%3D%22en-US%22%3ERe%3A%20Entering%20symbol%20into%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2037034%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F918783%22%20target%3D%22_blank%22%3E%40Bob_Lac%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20would%20use%20the%20conditional%20format%3C%2FP%3E%3CP%3E%3CSTRONG%3EHome%3C%2FSTRONG%3E%20tab%20--%26gt%3B%20click%20on%20%3CSTRONG%3EConditional%20format%3C%2FSTRONG%3E%20on%20the%20%3CSTRONG%3Estyle%3C%2FSTRONG%3E%20group%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2037423%22%20slang%3D%22en-US%22%3ERe%3A%20Entering%20symbol%20into%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2037423%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F918783%22%20target%3D%22_blank%22%3E%40Bob_Lac%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EYou%20would%20you%20simple%20if%20formula%20if%20it%20is%20just%20adding%20arrow%2C%3C%2FP%3E%3CP%3EI%20assume%20that%20your%20data%20in%20cells%20B6%2C%20D6%2C%20so%20you%20can%20copy%20the%20arrow%20symbols%20and%20use%20them%20in%20the%20formula%3CBR%20%2F%3E%3DIF(B6%26gt%3BD6%2C%22%E2%96%BC%22%2C%22%E2%96%B2%22)%3C%2FP%3E%3C%2FLINGO-BODY%3E
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)
Solution

@Bob_Lac 

 


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
=IF(B6>D6,"▼","▲")

@Jihad Al-Jarady 

 

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

@Bob_Lac 

You are welcome,