Conditional formatting and pivot tables


F

figdatbong

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
 
Ad

Advertisements

S

Sheeloo

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
=C1>B1
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...
 
Ad

Advertisements

F

francis

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top