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