Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
I have a few questions.
I am trying to get conditional formatting on a PivotChart. If the Actual HPU is larger than the Average HPU, I want the column to be red. If it is less, I want it to be green. I couldn't find anything about using conditional formatting on a PivotChart, but I read somewhere you could do conditional formatting on a PivotTable and then copy the formatting over to the chart. Any help would be appreciated. The other question is about multiple conditions needing to be met to have formatting. For example, if the Actual HPU is larger than the Average HPU AND the Percent Complete is 100%, have a red solid column (or even just filled cell). If the Actual HPU is larger than the Average HPU and it is not fully complete, have a red dashed column (or dashed cell). Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting Conditional Formatting Icon Sets | Excel Discussion (Misc queries) | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |