How to format your speadsheet with VBA
Submitted By: nogapo
The formatting features of Excel are a much-abused and reasonably flexible aspect that many companies rely on to make their work with the package a little easier to understand. Although there are a certain amount of options when it comes to conditional formatting, there are real limitations.
One of the limitations you will face often is the restriction of only 3 conditions to be able to base your formatting on. Therefore if you have a long list of variables to take into account then you are out of luck.
Good news though, we have a powerful macro language on hand.
Posted by: aa on Wednesday, November 23, 2011
Add Your Rating