• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conditional formatting in pivot

nika_garden

New Member
Dear!
please help me to apply conditional formatting in pivot table (attached file).

Creating pivot table, i have weeknumbers in columns and products in rows. As values in pivot table are quantities of sold products.
but there is one more parametr, source of sales (offline sales, online sales or sales with discount), and it is not included in pivot table rows or columns.

So i need to format values in pivot table, based on the condition:
if value in column A "Source" is online, then color value cell in pivot table in red,
if value in column A "Source" is offline, then color the cell in green,
if value in column A "Source" is sale, then color the cell in black.

I really appreciate your replies and hints!
Thanks!
 

Attachments

  • Cond Formatting Pivot.xlsx
    14.2 KB · Views: 3
  • formatting.PNG
    formatting.PNG
    67 KB · Views: 3
Back
Top