Conditional Formatting

[#1]

Can we do conditional formatting in a table in QlikView like we do in excel ?

I want to change the color of the cell based on the value of the number

[rustyfishbones · Accepted solution]

hi Sanmaan,

You can use the visual cues found here in the Table properties,

So if a number is greater than or equal to a certain number you can format the cell background, text color and make it bold, italic etc..

[#3]

Hi Alan thank you so much for your prompt help. it works like a charm

[#4]

Hi Alan,

its just letting me choose the upper and lower limit colour . the colour in between these 2 nos is getting shaded as lighter shade of the higher number and not the colour i choose ?

How do i work around this ?

[rustyfishbones]

Hi Sanmann,

just check what numbers you are adding to the Upper and Lower as both contain =

[#6]

Yes i did. the difference in the upper level and lower level is 10

The upper level colour is Green. The lower is Red. Still numbers lower than upper level are showing in light green