A few customers have mentioned it would be nice to have some type of marker on the Budget sheet that shows which category you’re dealing with when you’re budgeting. I thought this was a nice idea for an optional add-in. Here’s a little shot of what it will look like once installed:

If (Target.Column >= 2) And (Target.Column < = 78) Then
If (Target.Row <= 126) And (Target.Row >= 8) Then
Range("A8:A126").Interior.ColorIndex = 15
Range("A" & Target.Row).Interior.ColorIndex = 38
End If
End If
Note that this is for version 2.02 3.0 or later. Give it a test run and see how you like it. Any modifications are, of course, totally up to you.
RSS feed for comments. TrackBack URL
Thank you for your comment!