Re: Is it possible to load Colored cells of an excel sheet.?
That's not possible. The formatting of an excel cell is not imported, only the value. You'll have to recreate the color calculation in Qlikview. You could for example add a field in the script in the load statement:
If(Value < 0.8, rgb(255,0,0), rgb(0,255,0)) as Color
You can use the Color field in an expression for the Background Color option of a chart expression. Click on the + in front of the expression on the Expressions tab of the charts properties window. Select the Background Color option and add as color expression =only(Color)