Colored box when date is entered

O

oxicottin

Hello, I have a cell D10 that has a hire date for an employee. I also have a
calendar like chart (Cells B16 to AF27) which I add a letter in each box for
what that employee did for the day. Eample: if the employee worked I would
put an X if the employee was late I would put a UT If the employee was
scheduled off I would put a ---- ect. I have months down the left (A16 to
A27) and days 1 to 31 (B14 to AF14) Anyway i there a formula that would
change the color of a box/cell in my callendar that would tell me when the
employees hire date was?
Thanks,
Chad
 
Top