Mimicking the Conditional Formatting/Colour Scales from Excel in Qlik Sense

[Vern2022]

Hi all,

Could someone please kindly tell me how you Mimic the Conditional Formatting/Colour Scales from Excel in Qlik Sense? 

If there is not a way to do this in Qlik Sense, can someone share the mathematical formula for how the colours are defined in Excel Conditional Formatting/Colour Scales. If someone can tell me how to do this, I can then write an expression in the back ground colour properties for the measure.

Many thanks.

[Chanty4u]

You can use

RGB(255,0,0)

RGB(0,255,0)

Like you can use bg color  based on your colour code.

[Vern2022]

That did not answer my question. Thanks for picking my hopes up.

[2019hc04025]

I hope this link will help you to understand how conditional formatting works in the Excel.

https://www.contextures.com/xlcondformat01.html#howwork

[G3S]

you can have the conditional colour scales in the background colour expression. colour can be either qlik colour function or rgb or hex. 

for example, 

if(YOURmeasure<1,red(),

if(YOURmeasure<3,yellow(), Green() ))

see this:

https://help.qlik.com/en-US/sense/February2023/Subsystems/Hub/Content/Sense_Hub/Colors/color-by-expr...