Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Excel VBA

Excel VBA

ResolvedVersion Standard

Tue 25 Mar 2008, 16:19 Delegate Arabella said...

Arabella has attended:
Access Introduction course
Access Intermediate course
Access Advanced course

Excel VBA

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

Fri 28 Mar 2008, 15:34 Trainer Roy said...

RE: Excel VBA

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

Training courses

98.7 % recommend us

More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Recently used file list

Under the File menu, you may find a list of files at the bottom of the menu. These files represent the most recently used Excel spreadsheets. This file list provides a quick way for you to access your files.

You can disable the file list feature of Excel. This is done by

1. Choose Tools > Options menu. You will see the Options dialog box.
2. Ensure the General tab is selected.
3. Make sure the Recently Used File List check box is cleared.
4. Click on OK.

View all Excel hints and tips

Excel VBA

Excel VBA

RE: Excel VBA

Excel articles

Excel tip:

Recently used file list