Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
---|---|
Try:
=if(getselectedcount(DEP) and DEP=DEP,Yellow(),Only({1}if( Type = 'A', RGB(102,153,255), RGB(166,218,140))))
Try color expression with set {1} like:
=Only({1} if(Type = 'A', RGB(102,153,255), RGB(166,218,140)))
yes .. that works - but having done that - the colour showing the DEP selected was visually good! Can I do both in some way???
Jo
Sorry, I could not follow. Could you explain a bit more?
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
Try:
=if(getselectedcount(DEP) and DEP=DEP,Yellow(),Only({1}if( Type = 'A', RGB(102,153,255), RGB(166,218,140))))
Yest thank you - that works beautifully