98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Excel VBA
Excel VBA
Resolved · Low Priority · Version Standard
Tue 25 Mar 2008, 16:19Delegate 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:34Trainer 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 information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Sorting data stored in rowsPrimarily Excel is set up to sort data that is stored in columns rather than rows. |
