To apply conditional formatting: The cells with above average values are highlighted.When you apply conditional formatting to a block of cells in the pivot table, the formatting rule is applied to those cells only.
One well-known problem is that if you apply conditional formatting to both your row fields and the data items, like this: and then refresh it, the formatting is wiped from the data (values) area, as shown below: There are a couple of ways to fix this.
One is to specifically apply the formats to the values area(s), a new feature as of Excel 2007.
Conditional formats added this way aren’t cleared by pivot table refreshes: This works fairly well as long as your data area only includes one values field, but if you are pivoting on multiple values fields, you’ll have to add the rule for each one.
Yes by deploying some neat conditional formatting tricks you can produce a presentable usable Gantt chart in Excel.
This would usually mean lot’s of time consuming manual editing of cells. Step in Excel and the ever flexible conditional formatting function!