Carla has attended:
Upgrade to Office 2007 course
Conditional Formatting
How to conditionally format multi levels of information both + and - and decimal points.
RE: Conditional Formatting
Hi Carla, thanks for your query. I think we went over this in the training session, but you can simply add multi-levels of conditional formatting using the New Rule and Manage Rules options on the dropdown. Just be careful if you add any graphical formatting (particularly the traffic lights on top of the data bars) because they will compete and only the last one applied will be rendered. Let me know if you need any help constructing the actual criteria for the formats.
All the best,
Anthony