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 sli...
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