Forum home » Delegate support and help forum » Microsoft Office general help » Conditional Formatting
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Conditional Formatting
Resolved · Low Priority · Version 2007
Reply Wed 30 Jun 2010, 15:48Delegate Carla said...
Carla has attended:
Upgrade to Office 2007 course
Conditional Formatting
How to conditionally format multi levels of information both + and - and decimal points.
For upcoming training course dates see: Pricing & availability
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
Sat 10 Jul 2010: Automatically marked as resolved.
|