Forum Discussion
Need help in importing data from web. Conditional formatting not working on imported data
That's since all such columns most probably are formatted as text. If you replace all "-" on nothing or zero, and convert the rest to numbers, conditional formatting shall work on columns with numbers.
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.
I see on you screenshort that these columns are formatted as text. You tried to convert to numbers and still have texts or you tried something else?
n 2010 perhaps similar query returned numbers, not text.
Well, if I am formatting the data into number after loading the table then it is not working. Albeit, if I am formatting it in power query editor before loading it on spreadsheet then it is working. Seems like a solution was found. Thanks alot.
That's what I suggested and maybe you didn't pay attention to what I was suggesting.
