Hi,
I hoping someone can assist me here. I downloaded the Employee Attendance Tracker template which I'm trying to modify to suit my needs.

The original template had 6 fields of which 4 fields are reflected in color.
The remaining 2 fields were modified to for the other 2 types of leave that we have. This works fine but I am unable to get the color to reflect in the calendar and I have no idea how to adjust.

Any help in adjusting this template would be greatly appreciated.

I attached the one that I am working on and the original one.

Thanks,
Mitka

Attached Files

	Employee attendance tracker Original.xlsx (35.9 KB, 13 views)
	Employee attendance tracker Modified.xlsx (63.0 KB, 15 views)

I really tried to help on this but since I do not currently have the version of office you are using. I am quite limited. It appears to be a conditional formatting issue and I am not sure how many conditions your version can support. If it can accept 6 you may just need to give the cells the other condition.

Sorry I can't be of any more help.

I have the right version of Excel, but I looked at that template and threw my hands up in horror (no, not literally ); the formulae used there are quite a challenge. I still hope someone smart will look at this—Pecoflyer seems to be good with array formulae, which is what your template is using—but if no one else will tackle it, I'll try to get to it later today.