Hello!
I have a tab in Excel that feeds my Pivot Table. On that tab are three main columns: Team Member, Client, Likelihood - followed by a column for each week. I have created a pivot table that groups the data entered together first by Team Member and then by Client for each month. I would like the data in the cells to have a Red background color if the likelihood is less than 50%, a Yellow background color if the likelihood is between 50% and 80%, and a Green background color if the likelihood is greater than 80%.
Is that doable in Excel 2013?
Thank you!
Screenshot.png
Bookmarks