"carrera" wrote:

Back on task here, how do you assign a serial # to a particular cell?

It's obvious by now I have a good idea of what I'm trying to accomplish, and
simply require an assist. If you give me all the options you can think of,
I'm confident I will find the one that best suits. That would seem to be more
efficient than these "getting to know you" posts. You'll have to take my word
for it that I know what I want.

Actually, if there is an actual employee of microsoft that can address this
without the commentary, dare I hope for an MVP, I'd be grateful. I'm trying
to work here, not get the 3rd degree.

"HALinNY" wrote:

Carrera, you have to be more careful when you read the thread. The latest
post is not always at the bottom.

I posted the following response to you at 1342:

You currently have some formula that will place an X in the cell if a set of
conditions is met. The X is merely a marker; it has no intrinsic value and
can be replaced with any other marker. I suggest the formula now looks like
this...

=IF(<logical-expression,"X","")

Change the formula to this ...

=IF(<logical-expression,MAX(c$1:cx)+1,0) where c is this column and x=the

number of the row above.
Thus, if the formula was in cell G35, it would be...

=IF(<logical-expression,MAX(G$1:G34)+1,0)

By doing this you should get a serial number if the time segment is active.
You will have to work out how to begin the value with 0 on the first sheet
and carry it over to the next day, every day, but by using the MAX() function
it should be fairly straightforward.

So when you are all done with entering the times worked you will have for
each employee a column with a lot of zeros and 16 or so consecutive numbers
for an 8 hour day.

Now for the conditional formatting of each cell that represents a time
segment worked.

If the value in the cel is 0, format white text and white pattern.

If the value is between 1 and 80, format green text and green pattern.

If the value is greater than 80, format red text and red pattern.

The values will "disappear" and the entire cell will assume the color you
intended. This should look better than just having an X.

MVPs are not Microsoft employees. You have to PAY for Microsoft to help you
unless you within your initial assistance period or you have some kind of
arrangement with them. That is why Microsoft sponsors these forums.

B+
HALinNY