Conditional formatting a cell background

[danielburman]

Hi,

I have been asked to add some conditional formatting to a qlikview report based upon the value in a cell in straight and pivot tables. I have managed to get it to work using 2 values but we have 7. The table should be:

KPI ID	Owner	Oversight	Status
1	Jon S	Pal T	On track
2	Deb C	Dev P	Slight delay

I have got this to work: =if(Status='On track', RGB(0,112,192)) or =if(Status='Slight delay', RGB(0,112,192)) but we have 7 different status' each with its own RGB colour

When I try this everything stops working

=if(Status = 'On track', RGB(83,129,53)or
if(Status ='Slight delay', RGB(255,255,0)or
If(Status ='Off track', RGB(255,192,0)or
if(Status ='Delayed', RGB(255,0,0)or
If(Status ='Not started', RGB(217,217,217)or
if(Status ='On hold', RGB(166,166,166)or
If(Status ='Completed', RGB(0,112,192))))))))

Any help gratefully received

Dan

[danielburman]

Spent some time playing and it may not be the most elegant solution but this seems to do the job

if(Status='On track',RGB(83,129,53),if(Status='Slight delay',RGB(255,255,0),if(Status='Off track',RGB(255,192,0),if(Status='Delayed',RGB(255,0,0),if(Status='Not started',RGB(217,217,217),if(Status='On hold',RGB(166,166,166),if(Status='Completed',RGB(0,112,192))))))))