I need help in establishing conditional formatting in pivot table. I have two sources of data that I am able to import onto two worksheets. The first table has item numbers, width of the item, height of the item, price of the individual item.
The 2nd table has the model number, width, height, and total number sold for the year. I am needing a few pivot tables. I need a price grid of individual models by width and height (width is my column, height is my row, filtered by model # - got that far) I need to add a coloring (conditional formatting) to the values by sales.
I need another pivot table that can do a grid that can compare the price of the base model to the chosen model.This grid would have a percentage of the difference in price. still with the width in column and the height in the row.
Beyond the basic single price grid by size....I am lost
Solved by F. J. in 25 mins