automatic data insert

Hi!

I need some help please.

I'm trying to do an excel book that allows me to register every day a worker skips a day of work (no matter if is holiday or sickness). For that, i created two sheets, one with the list of absent day (like holiday, sickness, training, etc) with matching colors and codes, and another sheet with a calendar and workers names.

what i want to be able to do is, when i go to the calendar sheet and insert a absent code (in a certain day and worker) the color will be displayed as well.

i tried conditional formating the cells, but i can only have 3 colors linked to 3 codes.

can anyone help me?

Originally Posted by ozzbaldo

Hi!

I need some help please.

I'm trying to do an excel book that allows me to register every day a worker skips a day of work (no matter if is holiday or sickness). For that, i created two sheets, one with the list of absent day (like holiday, sickness, training, etc) with matching colors and codes, and another sheet with a calendar and workers names.

what i want to be able to do is, when i go to the calendar sheet and insert a absent code (in a certain day and worker) the color will be displayed as well.

i tried conditional formating the cells, but i can only have 3 colors linked to 3 codes.

can anyone help me?

Can you supply an example of your workbook?