T
Tacrier
Hi there!
I had posted this question last week and didn't get far without the analysis
add-in. I got it now but am missing the instructions on the howto?
What I would like to do is colour code a spreadsheet for work handedin by
staff.
I have the top row showing the calendar months from April 2008 to March
2009. The second row shows the due date to the SUpervisor and the due date
for review for each month like this:
Column A2:A3 = April 2008
Column B2 = May 7, 2008
Column B3 = May 14, 2008
The columns C-Z continue on like this with different due dates for each month.
Column A1:A200 = Employee Name
Cells entered with a date within the two particular due dates in a month I
would like coloured pink.
Cells entered with a date after the review due date in a month I would like
coloured blue.
Cells that have no entry I would like coloured grey to indicate missing work
not handed in.
Is this possible?
Any help is greatly appreciated.
Thanks!!
I had posted this question last week and didn't get far without the analysis
add-in. I got it now but am missing the instructions on the howto?
What I would like to do is colour code a spreadsheet for work handedin by
staff.
I have the top row showing the calendar months from April 2008 to March
2009. The second row shows the due date to the SUpervisor and the due date
for review for each month like this:
Column A2:A3 = April 2008
Column B2 = May 7, 2008
Column B3 = May 14, 2008
The columns C-Z continue on like this with different due dates for each month.
Column A1:A200 = Employee Name
Cells entered with a date within the two particular due dates in a month I
would like coloured pink.
Cells entered with a date after the review due date in a month I would like
coloured blue.
Cells that have no entry I would like coloured grey to indicate missing work
not handed in.
Is this possible?
Any help is greatly appreciated.
Thanks!!