Excel VBA

The UK's most regular instructor-led training courses.
Training information: excel one day course london · Excel courses · VBA training in London

Resolved · Low Priority · Version Standard

Excel VBA

Arabella has attended:
Access Introduction course
Access Intermediate course

by - delegate Arabella [6 posts] (2008 Mar 25 Tue, 16:19) Reply

how to colour a number of cells if the value is greater than 0 in some or all of the cells

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Oct 13 Mon + 14 Tue	Bayswater	0	FULL
2003	2008 Oct 23 Thu + 24 Fri	Southwark	0	FULL
2003	2008 Oct 30 Thu + 31 Fri	Bloomsbury	1	book now	£495	£495
2003	2008 Nov 3 Mon + 4 Tue	Bayswater	4	book now	£475	£485
2003	2008 Nov 17 Mon + 18 Tue	Southwark	5	book now	£450	£485
2003	2008 Nov 26 Wed + 27 Thu	Bloomsbury	6	book now	£450	£485
Full Schedule: See all 40 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Excel VBA

by - trainer Roy [23 posts] (2008 Mar 28 Fri, 15:34) Reply

Arabella,

You don't need VBA for this.

In Excel, just select the cells (or a whole column) and from the menus pick >Format >Conditional Formatting.

Set "Cell Value Is" "Greater Than" 0, and set a format (e.g. colour). You can Add>> further conditions/formats if you want.

/Roy

· Identifying Suitable Candidates For VBA For Excel Training
· How to Create Better Excel Spreadsheets: Part Four
· Crazy Things People Have Done With Excel
· 3 Reasons Why Excel Training Courses For Employees Can Improve Your Business
· Do You Really Need Excel VBA Training?

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

Excel tip:

Use the Format Painter to copy formatting more than once in Excel

The format painter tool provides a quick and easy way to copy formatting from one cell to another in Word.

The only problem is that if you click the Format Painter once to turn it on, you can only click and drag over a single cell or adjacent range of cells; then the Format Painter turns itself off automatically.

If you want to copy formatting to cells or groups of cells that are not adjacent to each other, double-click the Format Painter - this way you will be able to copy formatting to multiple cells.

When you have finished using Format Painter, press the Esc key or click on the Format Painter button once to turn it off.

View all Excel hints and tips