excel advanced - Colour formating

Resolved · Low Priority · Version Standard

Colour formating

Rosemary has attended:
Excel Advanced course

by - delegate Rosemary [1 post] (2007 Mar 28 Wed, 09:49) Reply

Is it possible to colour cells as result of a condition? ( if ..)

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 3 Wed	Bloomsbury	0	FULL
2003	2008 Dec 5 Fri	Bayswater	1	book now	£195	£205
2002/XP	2008 Dec 10 Wed	Tooting	0	FULL
2003	2008 Dec 10 Wed	Bloomsbury	0	FULL
2007	2008 Dec 10 Wed	Bloomsbury	2	book now	£240	£245
2003	2008 Dec 12 Fri	Southwark	5	book now	£219	£235
Full Schedule: See all 96 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: colour formating

by - trainer Amanda diamond contributer [1243 posts] (2007 Mar 28 Wed, 15:31) Reply

Hi Rosemary

Thanks for your question.

Yes, this is something you can do through Conditional Formatting (under the Format menu). This allows you to specify up to three separate conditions with associated formatting (e.g. change cell colour) for a group of cells you select from your spreadsheet first.

Amanda

· How to Create Better Excel Spreadsheets: Part Two
· Training Budgets In A Bad Economy
· Prepare for your MOS Certification with MS Excel Courses
· A Beginners Guide To Formulas In Excel
· Microsoft Excel Cheat Sheet: Tips and Shortcuts

Excel tip:

Bracketed negative numbers

Often Excel users wish to display negative numbers in colour red and bracketed

Intstructions
Step1. Select Format > Cells menu options. Within Numbers tabsheet, select Category = Custom.
Step 2. Select a type such as #,##0;[Red]-#,##0;; that specifies a colour in square brackets.
Step 3. Amend as follows; #,##0;[Red](#,##0;;

Notes: Excel formatting featues are of the form
"Positive; Negative;Zero;Text" separated by semicolon.

View all Excel hints and tips

Rate this page: