Hello all , I am a newb .. but I found in the free templates section of excel an employee attendance tracker , I think its great , but I wanted to modify it to my need just a little. If you download the template and look at the first sheet wich is the Calendar View.. there are colored squares in the legend at the bottom. When entering data the calendar table changes cell colors based on the input on the second sheet. I am trying to add two squares for additional dat to the legend , which I have done , but I cannot figure out what is linking the color of the legend squares to the cells in the calendar . When I add my two know legend squares and fill them with color , I can get my calculations to work out though out the entire work book , but no matter what I have tried , I can't get the color of my new legend squares to report to the calendar table. Thanks in advance for any help with this . Id love to know what I am missing .
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Attendance tracker Template
Your description maybe quite meaningful to you but I am quite lost.
I do understand in part but an image or worksheet sample would be of greater assistance.
Either use one of the options suggested by the site, or use a cloud-sharing facility.
From there we may be able to correspond.
I do understand in part but an image or worksheet sample would be of greater assistance.
Either use one of the options suggested by the site, or use a cloud-sharing facility.
From there we may be able to correspond.
Upvote
0
well neither is Unex Sick , but that is because I had altered the formula for that one while in there messing around , I have it fixed now , you see , # of sick days through the yellow square Unex sick came complete with the original template I downloaded , I added , or copy and pasted the other two (Unex Personal, Unex Vacation) .. and though I can get them to respond to input on another sheet , I cannot get the colors to report to a given cell or cells based on the leave type.
Upvote
0
I am almost sure it is conditional formatting some how , but I don't really understand how to duplicate it. The template that I am talking about is literally free in the excel templates section when words Attendance Record is typed into the search bar. I was hoping I could get someone to just download it and go over the file with to figure out how I can duplicate parts of it .. the current image I linked above is unavailable , I will repost it later .
Upvote
0
Similar threads
- Question
- Question
