Exce adv

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

Resolved · Low Priority · Version 2003

Exce adv

Rebecca has attended:
Excel Advanced course

by - delegate Rebecca [1 post] (2008 May 20 Tue, 10:15) Reply

How do you change the coclur of a cell if a statement is true/false
eg. Answer=No then cell=red
=yes then cell=green

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

RE: Exce adv

by - trainer Amanda platinum contributer [945 posts] (2008 May 23 Fri, 15:24) Reply

Hi Rebecca

Thank you for your question; and welcome to the forum.

You can get Excel to apply formatting based on what is contained within a cell by using Conditional Formatting.

This is found under the Format menu - Format/Conditional Formatting.

If you wish to set more than one criteria for the cells you have selected, then click the Add button once you have put your first criteria in place.

You can have up to 3 different criteria for the same group of cells.

I hope this helps.
Amanda

· Microsoft Excel Features and Functions for Accountants
· Microsoft Excel Training: Essential for Today's Employees
· Customized Financial Excel Courses in London
· Database Tips from an Excel Training Course
· Tools From Advanced Excel Courses: Goal Seek and Solver

Please browse our web site to find out more about
excel 2003 visual basic intermediate course and other Microsoft training courses.

Excel tip:

Closing all your workbooks Quickly

Hold the SHIFT key down and using the mouse click on the file menu, it will now now CLOSE ALL rather than close. This closes all workbooks down but still leaves the application open.

View all Excel hints and tips