Alternate row colouring that also works when sheet is filtered?

[Pete_UK]

Well, I'm glad to hear that it worked okay for you, though Dave and
Gord were the main contributors to this thread.

I share your sentiments about Access - maybe once I retire (several
years away yet) I might devote some time to getting to know it better.

Thanks for feeding back.

Pete

Glad to be of help - keep us informed ...

Pete

[snip]

That is just pretty, freakin' amazing! <g>

I tested it yesterday but decided to wait till today to test again ...
fresh day, rested mind and all that.  Well, I filtered every column
this morning and the code I now know has made the data just about as
easy to look through and work with as can be imagined.  The alternate
row colouring works perfectly; so in conjunction with row numbering
that also adjusts for filtering and code that allows filtering to work
even on protected sheets, can't see how this could get much easier!

As an aside, I saved the sheet in my tips folder and I can foresee it
being the basis for most future Excel spreadsheets since it this
worksheet has the features that I use the most in Excel.  Let's face
it, we often need to come up with some way to have a database of
information but Access just takes too long and much more skill than
most of us possess to use on a regular basis.  Yes, I can set up
rudimentary databases in Access but they take a lot more time to do
up.  An Excel spreadsheet takes care of most needs even though that's
not what it was written for, strictly speaking -- yet we all use it
for tracking and manipulating data.  With these 3 bits of code that I
have plus a few other things, I have the best of everything:  the
speed of set up and ease of use since most people understand Excel to
some degree (unlike Access), yet you can usually protect the data
enough that it's not as easily corrupted as an unprotected sheet would
otherwise be.

Thanks everyone!  As I say so often, where would I be without all this
fabulous help!  I'd still be able to function but nowhere near the
levels that I do now consistently.

Cheers!  D