Forum Discussion
Traffic lights showing incorrect color when used with slicer in a pivot table.
Hello Everybody,
In a pivot table (having collapsed rows), for a particular column (showing percentage values) I have applied traffic lights which are available in conditional formatting. Here slicers are also created by selecting pivot cells.
Now when we are selecting an/any option from slicers, the traffic lights are showing incorrect colors for respective percentage values.
We have tried multiple ways to fix it but yet they all fail. Please help if somebody knows on the same.
Thanks,
Hitesh.
Hello all,
this issue has been fixed. I am writing down the solution for future help to anybody who gets stuck here.
Excel calculates and stores percentage values in a different way. Solution to this issue is enter the values in decimals and in type select Number in Manage rules in conditional formatting.
Hope this proves useful.
BR
Hitesh Ved
