Excel 2010 - use a formula on a pivot table values to color cells on the column next to it

Can you use conditional formatting?

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Take a look at the conditional formatting rules for a pivot table from a question that was solved some time back. The values in the corresponding column are 1 and 2. After selecting the range of cells to which I wanted the rules applied, I set up conditional formatting using two rules. If this isn't helpful, please upload a sample (a two or three row pivot table should be enough) of the file from which the screenshot was made so that members can test their proposed solutions.
Let us know if you have any questions.

Originally Posted by ofirmarco

I will try to create a manually table with the same data and upload it later.
I will look into the post you shared, see if it helps.
thanks!

Yeah, this is why we say "SAMPLE" workbook, as we know people cant share all their data. The point is that you get a representative example of your problem so we can solve that SO you can implement that solution in your real data/workbook.

You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools link above your first post. I hope that you have a blessed day.