LaurenHancy
Board Regular
- Joined
- Aug 5, 2010
- Messages
- 179
Hello All!
I am quite stuck and I am sure you lovely lot will be able to solve my mystery!
So my aim is to find out which cells with a criteria of "Name" & "Date" are red. When a person is late, the cell which is a time, is colored Red.
I have names in cells A, and the date in the header going from C5:YC5. Each person has their own row and times in the cells, when they are late, I colour the cell red. is there any way to count the number of red cells per name for each month, Jan, Feb etc?
I hope you can help me
Thank you.
X
I am quite stuck and I am sure you lovely lot will be able to solve my mystery!
So my aim is to find out which cells with a criteria of "Name" & "Date" are red. When a person is late, the cell which is a time, is colored Red.
I have names in cells A, and the date in the header going from C5:YC5. Each person has their own row and times in the cells, when they are late, I colour the cell red. is there any way to count the number of red cells per name for each month, Jan, Feb etc?
I hope you can help me
Thank you.
X