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 .