I recently did a quick $50 Project for a long-time client who wanted a certain spreadsheet to have the feature where if there was any value in column B, the formatting of column A in the same row would be indented by 1. Since the built-in conditional formatting cannot do this, it took a few lines of VBA.
Simple and straightforward.
Enjoy the file, Excel_Geek Insiders.
Later,
Excel_Geek
Wednesday, February 27, 2008
Conditional Indenting
Posted by Excel_Geek at 6:38 PM
Labels: $50 Project, Conditional Formatting
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment