Which colour takes precedence?

[josephinetedesc]

Hi all

I want Type A and Type Be to show in different colours. as per Header1

but

when I select by Department I lose the colour ???

Jo

Header 1	Header 2

[tresesco]

Try color expression with set {1} like:

=Only({1} if(Type = 'A', RGB(102,153,255), RGB(166,218,140)))

[josephinetedesc]

yes .. that works - but having done that  - the colour showing the DEP selected was visually good!  Can I do both in some way???

Jo

[tresesco]

Sorry, I could not follow. Could you explain a bit more?

[josephinetedesc]

If you look at the second image (Header B) - When DEPA selected then - then DEPA is highlighed in blue - which you don't want in blue - but could be useful if it was in another colour.

Jo

[tresesco · Accepted solution]

Try:

=if(getselectedcount(DEP) and DEP=DEP,Yellow(),Only({1}if( Type = 'A', RGB(102,153,255), RGB(166,218,140))))

[josephinetedesc]

Yest thank you - that works beautifully