Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Comunity.
I am trying to color code the Items in the month section of the Pivot table and I am unable to color code the concatenated items (see attachment). I have tried using a combination in the formatting under Expressions and I could not get it to work. Do I need to create a wildcard item?
[Cans,Scrapers]
Try this
=If(Count(DISTINCT Item) > 1, LightRed())
Can I specify by combination? So if it Cans,Scrapers vs Trophies,Spades?
Not sure I understand, can you elaborate?
The method you specified when I applied it in my workbook changed all the different concatenated types. Am I able to specify which concan=tenated types should be a specific color?
Scraper,Trophies = RGB(100,150,200)
Cans,Scrapers = RGB(255,200,150)
Try this
=If(Concat(DISTINCT Item,',') = 'Cans,Scrapers', RGB(255,200,150),
If(Concat(DISTINCT Item, ',') = 'Scrapers,Trophies', RGB(100,150,200)))
You are just a genius Sunny, and a valid asset to the community!
You have no idea how I have suffered to get that together
Am I able to have a two color gradient within the cells?
I noticed that in the Styles tab in Properties I can have two gradient colors but it did not take effect when enabled. Also, in the Custom Format Cells right click option, it is disabled (greyed out).
I would like to see if I can have two colors for the fields that are concatenated: A diagonal gradient showing the two colros split for th eitem.
Any ideas?