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
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