Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Conditional formatting

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Conditional formatting

Resolved · Low Priority · Version 2007

Reply Wed 29 Jun 2011, 16:49Delegate Jenny said...

Jenny has attended:
Excel Intermediate course
Word Advanced course

Conditional formatting

Can you format a whole row by colour even though the criteria is only in one column?

For upcoming training course dates see: Pricing & availability

Reply Thu 30 Jun 2011, 09:30Trainer Stephen said...

RE: Conditional formatting

Hi Jenny

Thanks for your question

Please could you expand a little on your question. Are you looking to format a whole range based on the value in a single cell.
So for example if the first cell in the row contains a particular value, then the whole row is formatted?

Thanks

Stephen

Reply Mon 11 Jul 2011, 09:43Trainer Stephen said...

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Sun 17 Jul 2011: Automatically marked as resolved.

Excel articles

· Benefits of learning about Excel charts
· Want To Create A Presentation In Excel?
· Easing the Transition to Excel 2007
· Data Basics Using Excel
· You're Hired! Raising Your Chances Of Employment With Excel

Please browse our web site to find out more about
microsoft excel training in london and other Microsoft training courses.

Excel tip:

Remove unused toolbar buttons

Are there buttons on your Excel toolbars that you never use? Remove them from the toolbar by doing the following:

1. Go to Tools - Customise - Commands.
2. Select the toolbar button you wish to remove, then use your mouse to drag and drop the button into the Excel window. When you release your finger from the mouse, the button will disappear.

View all Excel hints and tips