Conditional Formatting

Resolved · Low Priority · Version 2007

Wed 30 Jun 2010, 15:48 Delegate 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.

Sat 3 Jul 2010, 11:25 Trainer Anthony said...

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

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Microsoft Office tip:

Using the Quick Access Toolbar in Office 2010

The Quick Access Toolbar is included in virtually every Office product, including Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010.

You will find the Quick Access Toolbar in the top-left side of the window. To begin, click the Customize button (it's the little black arrow at the end of the toolbar).

Simply click the commands you want to include.

Virtually any command can be added to the Quick Access Toolbar. Click the More Commands option and a new window will open from where you can browse the commands including those not on the ribbon.

View all Microsoft Office hints and tips