FORMAT CELL

%3CLINGO-SUB%20id%3D%22lingo-sub-1379202%22%20slang%3D%22en-US%22%3EFORMAT%20CELL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1379202%22%20slang%3D%22en-US%22%3E%3CP%3EI%20WANT%20TO%20PUT%20UPPER%20ARROW%20AND%20DOWNWARD%20ARROW%20FOR%20THE%20CELL%20WHEN%20PRICE%20GOES%20UP%20OR%20DOWN.%3C%2FP%3E%3CP%3EITS%20A%20EXCEL%20ONLINE%20SHEET%20WHERE%20DATA%20IS%20CONNECTED%20ONLINE.%3C%2FP%3E%3CP%3EPL%20GUIDE.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1379202%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1385102%22%20slang%3D%22en-US%22%3ERe%3A%20FORMAT%20CELL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1385102%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F663062%22%20target%3D%22_blank%22%3E%40SANDEEPLAGOO65%3C%2FA%3E%26nbsp%3BYou%20can%20do%20so%20selecting%20the%20price%20list%20data%20both%20which%20was%20earlier%20and%20which%20is%20current%20price%20and%20go%20to%20HOME%2FCONDITIONAL%20FORMATTING%2FICON%20SETS%20-%20and%20select%203%20Arrows%20Colored%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20will%20highlight%20your%20price%20list%20based%20on%20previously%20set%20prices.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20this%20helps%20you.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1388818%22%20slang%3D%22en-US%22%3ERe%3A%20FORMAT%20CELL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1388818%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F402789%22%20target%3D%22_blank%22%3E%40AshaKantaSharma%3C%2FA%3Esee%20I%20am%20getting%20the%20price%20data%20in%20one%20cell.%3C%2FP%3E%3CP%3EI%20want%20it%20should%20give%20me%20the%20upper%20or%20downward%20arrow%20when%20the%20price%20is%20up%20or%20down%20per%20minute.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I WANT TO PUT UPPER ARROW AND DOWNWARD ARROW FOR THE CELL WHEN PRICE GOES UP OR DOWN.

ITS A EXCEL ONLINE SHEET WHERE DATA IS CONNECTED ONLINE.

PL GUIDE.

2 Replies
Highlighted

@SANDEEPLAGOO65 You can do so selecting the price list data both which was earlier and which is current price and go to HOME/CONDITIONAL FORMATTING/ICON SETS - and select 3 Arrows Colored

 

This will highlight your price list based on previously set prices. 

 

Hope this helps you. 

Highlighted

@AshaKantaSharmasee I am getting the price data in one cell.

I want it should give me the upper or downward arrow when the price is up or down per minute.