michaltrom
New Member
- Joined
- Jun 13, 2018
- Messages
- 2
I've a file with colored fields. I want to create pivot table that take under consideration the colors of the fields. I thought that if I'll have a formula that recognize the color by number or other indicator I could create another column and run a pivot accordingly. I tried "=CELL("color",F2)", it's not working… Someone know a formula for that? Any other suggestion for that please?