The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

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

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

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

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

Training information:

Conditional formatting

Resolved · Medium Priority · Version 2007

ReplyMon 12 Jul 2010, 17:02Delegate Teju said...

Conditional formatting

How do you copy conditional formats?
Does excel 2007 permit the use of a combination of operands in conditional formatting e.g greater than or equal to (>=) ? if yes how does it work?

Thanks

For upcoming training course dates see: Pricing & availability

ReplyTue 13 Jul 2010, 11:47Trainer Stephen said...

RE: conditional formatting

Hi Teju

Thanks for your question

To copy conditional formatting simply copy and then paste special to the target cell, selecting "Keep Source Formatting".

The Operands in conditional formatting are accessed through commands such as "Greater than or equal to" etc. Go to conditional formatting and select "New Rule". Then choose "Format only cells that contain".

Hope this helps

Regards

Stephen

ReplyTue 13 Jul 2010, 14:49Delegate Teju said...

RE: conditional formatting

Thanks.

In addditon to paste special, can the format painter also be used to serve the same purpose (i.e. copying conditional formating)? Is on method better than the other?

Regards

ReplyFri 16 Jul 2010, 14:17Trainer Stephen said...

RE: conditional formatting

Hi Teju

This is in fact the method used by the format painter. The two are actually identical.

Regards

Stephen

Thu 22 Jul 2010: Automatically marked as resolved.

Excel articles

· Break The Mystery Of Code With Excel Macros
· Avoid Duplication In Excel By Ensuring Unique Values
· Creating Charts with Excel
· Some Mouse Click Tips In Excel
· Using Excel For Simple Home Accounting And Budgets

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

Excel tip:

Move data worksheet to worksheet

To move data from one worksheet to another, highlight the data.

Select and hold down the ALT key and position the mouse on the border of the selection until the mouse pointer displays four-headed arrows.

Drag the selection down to the destination worksheet tab.

When the arrow touches the tab, Excel switches to the desired worksheet. Now drag the selection to the correct position. Let go of the mouse and then the ALT key.

To copy data from one worksheet to another, select and hold down the CTRL+ALT keystroke combination and perform the steps above.

View all Excel hints and tips

Can the lookup value have formulas?