Bossie
New Member
I know how to apply conditional formatting to a pivot table. But I wonder if it is possible to add conditional formatting to just one column.
Say you have as rowlabels the years (2016 - 2017 - 2018) and as column labels the quarters (1-2-3-4) and as values your revenues. Say you need to highlight only the column with the first quarter (condition < column total).
So you see what year has a lower revenue in the first quarter.
There will be years added, so manually select the cells to format is not the right solution
Say you have as rowlabels the years (2016 - 2017 - 2018) and as column labels the quarters (1-2-3-4) and as values your revenues. Say you need to highlight only the column with the first quarter (condition < column total).
So you see what year has a lower revenue in the first quarter.
There will be years added, so manually select the cells to format is not the right solution