Hi,
Can I set conditional format based on icon set if the are of conditional formatting is picking up the logic from a diff cell.
So for "Month" column of pivot table Ive formatted the text red if "Dif" value <0
But can I not add icon sets in "Monnth" column to mirror icon set of "Diff" column (which is same formatting as "% Diff" column,
Just so can scan the months and no if the month was up or down.
So Instead of applyiong colour scale to "Net profit" I would keep the bars but apply that colour scale formatting to my "Month column"
Is any of this possible?
Many Thanks
Can I set conditional format based on icon set if the are of conditional formatting is picking up the logic from a diff cell.
So for "Month" column of pivot table Ive formatted the text red if "Dif" value <0
But can I not add icon sets in "Monnth" column to mirror icon set of "Diff" column (which is same formatting as "% Diff" column,
Just so can scan the months and no if the month was up or down.
So Instead of applyiong colour scale to "Net profit" I would keep the bars but apply that colour scale formatting to my "Month column"
Is any of this possible?
Many Thanks