Link to home
Start Free TrialLog in
Avatar of controlit
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.
Avatar of Thomas Rush
Thomas Rush
Flag of United States of America image

I don't think this is hard, if I understand what you're trying to do.

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. User generated image
ASKER CERTIFIED SOLUTION
Avatar of Jerry Paladino
Jerry Paladino
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial