controlit
asked on
group information user defined dynamic table in excel 2013
how i can to group information in excel user defined in dynamic table.
I have a pivot table with the source mysql database and I have a field called buffer
I need group by ranges so
between 0 and 33,9 -> green
between 34 and 66,9 -> yellow
between 67 and 100,9 red
greater than 101 gray
are many records
excel only you can group a range, but I have every range that is different
excel to have a origin of a database the records of PivotTable increase and decrease
is not constant
I can group rows in excel and then selecting the group and give the name to the group but the problem is that many records and change records. increase and decrement, so selecting it has a limit in the selection.
I have a pivot table with the source mysql database and I have a field called buffer
I need group by ranges so
between 0 and 33,9 -> green
between 34 and 66,9 -> yellow
between 67 and 100,9 red
greater than 101 gray
are many records
excel only you can group a range, but I have every range that is different
excel to have a origin of a database the records of PivotTable increase and decrease
is not constant
I can group rows in excel and then selecting the group and give the name to the group but the problem is that many records and change records. increase and decrement, so selecting it has a limit in the selection.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
As long as you know which cells you want the effects on, set them up with
Excel's Conditional Formatting -- once you have your rules in place, the
cells will get the right colors or effects, even if the values change.
See the attached. Blue arrow shows where you get to the conditional
formatting widget.