Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting and pivot tables
Hi all.
The following may, or may not be, achievable in Excel 2003, but I thought I'd give it a shot anyway. I have a pivot table connected via ODBC to an external data source. The structure of the table is very simple as the following illustrates: Report Date 09/02/2009 16/02/2009 23/02/2009 Officer 1 £200 £210 £155 Officer 2 £178 £198 £168 Officer 3 £234 £130 £210 What I would like the conditional formatting to do is highlight the current week value green if it is less than the value for the previous week, or red if it is greater than that for the previous week. Over a period of time, we should be able to see at a glance those periods where the officers did not act upon system generated recommendations. Any help would be much appreciated. Regards |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting and pivot tables
Select the whole Column C (I am assuming that the dates to be highlighted are
in Col C and are to be compated to Col B) Choose Conditional Formatting Choose FORMULA IS Use the formula =C1B1 Choose your format Add condition Use the formula =C1<B1 It should work as long as you don't change the structure of the PIVOT table... "figdatbong" wrote: Hi all. The following may, or may not be, achievable in Excel 2003, but I thought I'd give it a shot anyway. I have a pivot table connected via ODBC to an external data source. The structure of the table is very simple as the following illustrates: Report Date 09/02/2009 16/02/2009 23/02/2009 Officer 1 £200 £210 £155 Officer 2 £178 £198 £168 Officer 3 £234 £130 £210 What I would like the conditional formatting to do is highlight the current week value green if it is less than the value for the previous week, or red if it is greater than that for the previous week. Over a period of time, we should be able to see at a glance those periods where the officers did not act upon system generated recommendations. Any help would be much appreciated. Regards |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting and pivot tables
Hi
try this 1. Select the cells you want to format from C2 onward 2. Choose Format, Conditional Formatting 3. Choose Cell Value Is from the dropdown 4. Choose greater than from the dropdown 5. move to the third box and click B2 5. Click the Format button 6. Choose red color on the Patterns tab 7. Click Add 8. Repeat 3 to 6 for green and in step 4 choose less than from the dropdown 9. Click OK twice. -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis "figdatbong" wrote: Hi all. The following may, or may not be, achievable in Excel 2003, but I thought I'd give it a shot anyway. I have a pivot table connected via ODBC to an external data source. The structure of the table is very simple as the following illustrates: Report Date 09/02/2009 16/02/2009 23/02/2009 Officer 1 £200 £210 £155 Officer 2 £178 £198 £168 Officer 3 £234 £130 £210 What I would like the conditional formatting to do is highlight the current week value green if it is less than the value for the previous week, or red if it is greater than that for the previous week. Over a period of time, we should be able to see at a glance those periods where the officers did not act upon system generated recommendations. Any help would be much appreciated. Regards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to lock conditional formatting in pivot tables? | Excel Discussion (Misc queries) | |||
Conditional Formatting in Pivot tables | Excel Worksheet Functions | |||
Pivot Tables & Conditional Formatting | Excel Worksheet Functions | |||
Conditional Formatting and pivot tables. | Excel Discussion (Misc queries) | |||
Conditional formatting in pivot tables? | Excel Discussion (Misc queries) |