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 Tue 25 Oct 2011, 16:36Delegate Charlie said...

Charlie has attended:
Powerpoint Intermediate Advanced course

Conditional Formatting

How to get a cell formatted to a specific colour based on certain plus or minus figures

For upcoming training course dates see: Pricing & availability

Reply Wed 26 Oct 2011, 10:49Trainer Rodney said...

RE: Conditional Formatting

Hello Charlie,

Hope you enjoyed your Microsoft Excel Advanced course with Best STL.

Thank you for your question regarding conditional formatting.

All positive numbers are greater than zero and all negative numbers are less than zero. Select the data that requires conditional formatting and from the Conditional Formatting button use Highlight Cells Rules followed by Greater Than... Insert a Zero then choose your colour. Repeat the process, only this time use the Less Than option.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer

Tue 1 Nov 2011: Automatically marked as resolved.

Excel articles

· What Do The Formula Error Messages Mean In Excel?
· Tracking In Excel 2003
· Interesting Things About Charts In Excel 2003
· Do You Really Need Excel VBA Training?
· Organisation At Your Fingertips - Take Control Of Your Life With Excel

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

Excel tip:

Saving your Excel Spreadsheet as a CSV File

In situations where you need to save your Excel spreadsheet as a CSV file, follow these simple steps.

Click the File tab and click Save As.
Enter a name in the File name field.
Click the drop-down arrow next to the Save as type field to select the file type. Scroll down the list and select CSV (comma delimited) (*.CSV)
Click Save

The data will now be saved to a separate CSV file which can be used in different applications.

View all Excel hints and tips