Forum Discussion
Need help in importing data from web. Conditional formatting not working on imported data
I am importing data from this link - https://www.nseindia.com/live_market/dynaContent/live_watch/option_chain/optionKeys.jsp?symbolCode=-10006&symbol=NIFTY&symbol=NIFTY&instrument=-&date=-&segmentL...
Tried it. But the problem still persists. This was not the problem in office 2010 & 2013.
I tried that with legacy Web connector which returns numbers, not texts. Data bar conditional formatting works on returned result.
If use Power Query by default it converts these columns to text. If not Load but Transform and add couple of more steps - apply Decimal Number type to these columns and Replace all errors on nulls, it works as well.