Bruhahhahaha! Okay, I have no idea who you people are, you know the ones that
take the time to answer a bunch of questions from people like me. I mean of
all the places to be, you are here answering questions about Excel! Thank
you. So very very much.

As you can see, Im back again with another couplea questions. For those
familiar with me, yes, its the same spreadsheet. This thing is constantly
morphing.

NOTE: Before I post questions here, I do do (hehe, he said dodo) my best to
find the answers elsewhere before bothering you fine people but when it comes
to Excel, I dont even know WHAT to ask.

Question #1; The guy who created this originally did this nifty little thing
that I cant seem to replicate. Each separate worksheet (of which, there are
now 12) has 51 columns, which are identical to each other except for the
number of names in each worksheet. That is superfluous information. What is
important is the first three columns. They dont move! As I scroll left and
right, those first three columns stay right where they are which is VERY
convenient as they contain da names. Now, how in the name of Picard do I do
that!

Not enough info? Well there is a bold line separating columns €˜C and €˜D
and as I scroll right, itll go from €˜C to €˜E all the way to €˜C and €˜AY.
I thought this might be called a partition but I guess for Excel, partition
means something else.

Question #2; The Bosss Boss, Da Man, or as we like to call him, the
Commanding Officer, really liked what you guys helped me do so far and has
asked me to do some other nifty Excel magic. In this all consuming
spreadsheet is a worksheet dedicated to pistol qualification. Its pretty
straight forward. Four columns containing rank, name, qual date and score. A
couple little functions at the bottom calculating how many experts, how many
sharpshooters and so on.

These scores are good for one year. At the end of that year, the individual
needs to shoot again. What The Man, and by extension myself, would like to
know is if there is a way to alert us when that year is up. Now Ive had info
overload these last few days in learning just how Excel calculates time, (Jan
01, 1900 I believe) but that really hasnt helped me.

So what I envision is tweeking the column of dates, once the year is up, the
box turns red. Or something. Is this, or something roughly similar, possible?

Once again, I thank for your time and your patience and your understanding.
And most of all for being here to answer these questions. IMMEDIATE HELP!!!!
Hahahahaha!