Hello All,
Thank you for taking the time to read my question.
I am looking for a way to highlight colour of a cell in the total column with its corresponding column according. I have a pivot table with 5 columns: Details, Month 1, Month 2, Month 3 and Totals. Month1 is blue, month2 is green, month4 is yellow. I would like for a cell in total column to highlight a colour with to corresponding column in month 1, month 2 and month 3 so either blue, green or yellow. The corresponding column will never repeat so the value in column totals will match in just one of the columns between Month1, Month2, Month3.
Is there a solution for this?
thank you for your time.
Thank you for taking the time to read my question.
I am looking for a way to highlight colour of a cell in the total column with its corresponding column according. I have a pivot table with 5 columns: Details, Month 1, Month 2, Month 3 and Totals. Month1 is blue, month2 is green, month4 is yellow. I would like for a cell in total column to highlight a colour with to corresponding column in month 1, month 2 and month 3 so either blue, green or yellow. The corresponding column will never repeat so the value in column totals will match in just one of the columns between Month1, Month2, Month3.
Is there a solution for this?
thank you for your time.
