  |
|||
|
|
|
||
|
Posted by Guy Lecky-Thompson Jan 11, 2007 |
I've been playing with VBA again - largely thanks, or because of, my wife (a teacher) - looking at how to hilight cells with a value that might go up or down. Like a grade point average.
The idea is that we can use VBA in Excel to automatically hilight cell values of interest, without having to do it manually. My wife finds it really useful, coupled with being able to conditionally sum cells.
Recently I've covered both, and I have to admit that, from being a programmer, but not an Excel programmer, I've learned an awful lot. So, I'm sharing these experiences as little articles, so that readers of this site can benefit from my experiments.
Read the two articles (first one most recent):
Changing Cell Color Conditionally
Conditional Summing in VBA with Excel
While you're looking into Excel and VBA programming, you might be interested to note that the Computer Programming site at Suite101 also covers general programming topics (loops, functions, procedures, decisions etc.) and language specific topics such as C, C++, BASIC and so on. Just a thought.