training in excel - Formatting

The UK's most regular instructor-led training courses.
Training information: training in excel · Advanced.excel · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Formatting

Aljoscha has attended:
Excel Intermediate course

by - delegate Aljoscha [1 post] (2007 Aug 9 Thu, 16:32) Reply

How can I highlight a value in a cell that exceeds a set deviation level? For instance, a fund returns 10% over a week while its benchmark retuns 16%. A deviation of more than 5% should be highlighted in red?
thanks
Ali

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue + 26 Wed	Bayswater	6	book now	£455	£515
2003	2008 Nov 26 Wed + 27 Thu	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 1 Mon + 2 Tue	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	5	book now	£450	£485
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	5	book now	£475	£515
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	6	book now	£450	£475
Full Schedule: See all 37 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Formatting

by - trainer Alan silver contributer [73 posts] (2007 Aug 10 Fri, 13:40) Reply

Hi Ali

Use Conditional Formatting. Select the cells you want to highlight, go to the Format menu and choose Conditional Formatting. Set your criteria, click the FORMAT button and choose the highlight options you need. Click OK to activate.

Cheers!

Alan

· Microsoft Excel Training Advanced Courses - Making Data Validation Work For You
· Microsoft Excel Training: Not Just for Newbies Anymore
· From the Classroom to the Corporate World
· Microsoft Excel Training Course
· Customized Financial Excel Courses in London

Excel tip:

Adding date and time

Here are two quick ways to add the date and time to your spreadsheet:

1) Type =NOW(), which displays both date and time in the same cell
or
2) Hold Ctrl and type the colon (:) into one cell for the date and the semi-colon(;)into another for the time.

Note that =NOW() updates to the current date/time whenever the spreadsheet recalculates.

View all Excel hints and tips