Using colour to highlight results

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

Resolved · Low Priority · Version 2003

andrea has attended:
Excel Advanced course

by - delegate andrea [1 post] (2008 Apr 28 Mon, 16:48) Reply

I've seen colours automatically appear to underline where results are e.g. below/above par

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Jul 9 Wed	Bloomsbury	0	FULL
2003/XP	2008 Jul 9 Wed	Bayswater	2	book now	£195	£205
2003/XP	2008 Jul 16 Wed	Tooting	0	FULL
2003/XP	2008 Jul 16 Wed	Bloomsbury	1	book now	£235	£240
2003/XP	2008 Jul 18 Fri	Southwark	4	book now	£224	£235
2003/XP	2008 Jul 23 Wed	Southwark	0	FULL
Full Schedule: See all 143 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: using colour to highlight results

by - trainer Pete platinum contributer [600 posts] (2008 May 7 Wed, 22:25) Reply

Hi Andrea, Thank you for your post, welcome to the forum, in answer to your question, you should try Conditional Formatting, select your range of cells, go to the menu command, Format>Conditional Formatting, and apply your required Format to your cells, using the operators =, >, <, >=, <=, <>, and your figures for "par", I hope that has answered your question, if so please click the resolved link, regards Pete

· Microsoft Excel's Best Kept Secret
· Customized Financial Excel Courses in London
· Microsoft Excel Training: Not Just for Newbies Anymore
· 5 Microsoft Excel Charts for Creating Stunning Business Documents
· How to check for and reduce errors in Microsoft Excel

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

Excel tip:

Make macros work in newer versions of Excel

If you have created macros in Excel 97 or 2000 that you want to be able to use in 2002/XP or 2003, you may need to alter the macro security settings in the newer version of Excel you are using.

To do this, go to Tools - Options - Security.

Select Macro Security and change the security setting to Low.

Tick the boxes next to 'Trust Add-ins' and 'Trust Visual Basic' and click OK.

After you have restarted Windows, you should then be able to use your macros created in earlier versions of Excel.

View all Excel hints and tips