conditional background colour expression - if statement

[gilldilpreet]

Hi

I am trying to add a conditional expression to a field in my straight table so that the background colour will be orange if the Status = Leaver.

I am attached my progress with this so far...

Any help would be much appreciated!

Thanks

Dilpreet

[asinha1991]

what is the exact issue you are facing? you expression seems correct..

it will apply only to one cell. if you it for all cells, add same condition in all fields

[Frank_Hartmann]

Maybe this:

if(aggr([Status],Level)='Leaver',RGB(235,100,30),White())

[gilldilpreet]

It doesn't seem to be working?

Yes, I only want the colour to change in one cell.

Thanks

Dilpreet

[asinha1991]

the only reason I can think of is, Leaver either has different case or has additional spaces, maybe apply trim

[gilldilpreet · Accepted solution]

I have solved it - the transparency was 100%!