FORMAT CELL

Copper 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

@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. 

@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.