courses in microsoft access - Pivot Table - conditional formatting

Resolved · Low Priority · Version Standard

Wed 6 Dec 2006, 19:02 Delegate Jane said...

Jane has attended:
No courses

Pivot Table - conditional formatting

Can one do conditional formatting in a pivot table?

The pivot table I have set up shows allocated days per employee per month and I want to highlight Red; Amber; Green if total days per month are >20 (R); <=19(A) ; =20 (G)

Thanks, if not any other suggestions? Macros etc?

Thanks

Thu 7 Dec 2006, 11:53 Trainer Richard said...

RE: Pivot Table - conditional formatting

Jane

You can do this in Excel quite easily, as each cell can be formatted, just like you would normally, although it is in a Pivot table. One way you could get a result is if you export the table to excel and then PivotTable with standard conditional formatiing.

Access is slightly different, in that Pivot Tables is a view of a table, which is not highly formattable when it comes to conditional formatting. Forms and Reports have conditional formatting built in from Access 2000 level.

There may be ways of conditional formatting using VBA, although I have not had any experience with VBA, thereofr could not advise correctly in that area.

Training courses