Previous Topic Next Topic

Excel personnel tracking sheet

Closed
hudabble Posts 1 Registration date Sunday March 27, 2011 Status Member Last seen March 27, 2011 - Mar 27, 2011 at 11:20 AM
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - Mar 28, 2011 at 04:07 AM
Hello,

I am trying to make an excel sheet that counts consecutive days that a person is on the list...the list being days that certain personnel were present or not. For example, in the first column there is a list of names of personnel in alphabetical order. The names are highlighted either red or yellow depending if they were there that day....If the names are yellow 15 days in a row I want the name cell to turn a specific color and 16 days a different specific color. If the name column is red I want to reset the count back to zero. I figured that I could create a date column next to the name that changes to a set date once it is first highlighted yellow and creates the condition (first.yellow.date. + 16>actual date) and if red set conditions back to zero.......PLEASE ADVISE

2 responses

Answer 1 / 2
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Mar 28, 2011 at 01:25 AM
how have you designed the data sheet. post a very small extract. Instead of 15 days restrict to 5 days (for samplle purposes).take only five names

The solution depends upon the data sheet.
0
Answer 2 / 2
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 120
Mar 28, 2011 at 04:07 AM
Could you please upload a sample Excel file WITH sample data, macro, formula, conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc.
AND post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too.


P. S.: your data need not be to be real data but a good representative of how data looks like
0