Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

conditional formatting

Forum home » Delegate support and help forum » Microsoft Office general help » Conditional Formatting

Conditional Formatting

ResolvedVersion 2007

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

Sat 10 Jul 2010: Automatically marked as resolved.

 

Training courses

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Microsoft Office tip:

Switching Between Applications

When you are working with several applications at once, use the Alt+Tab key combination to switch between them. Keep the Alt key down and stab the Tab key until you reach the correct package, then release Alt.

View all Microsoft Office hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.