courses in microsoft access - 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.