Cross Tab reports can conditionally format row headers but not column headers? Why not?
I have a very simple cross tab report (table) that shows employees on one axis and the count of their performed inspections on the other axis. Inspections can be too short, too long, or just right. I want to apply conditional formatting so that good inspections are green, bad are red, etc. This works fine when the inspection status is in the row (see attached picture), but I have more employees than statuses, so I'd like the statuses to be the columns and the employees to be the rows. Should be easy right? Should just get nicely formatted column headers instead of row headers right?
Nope...for some reason the software is perfectly capable of formatting row headers but inexplicably prohibits you from formatting column headers. Makes no sense at all.