I wanted to write a VBA code which supports the following

L-Leave, S-Start, E-End, D-Date, CL- Casual Leave, SL- Sick Leave

Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu
Fri Sat Sun
Name L-S-D L-E-D Type 01 02 03 04 05 06 07 08 09 10 11 12 13
Vinod 3 9 CL CL CL CL CL CL
Chris 7 8 SL SL SL
Micale 2 2 CL CL

My Requirement is If I enter 3 values (L-S-D, L-E-D, Type ) then only the
event should be fired (if any one of 3 values is not available no need to
fire event) which does the action, the leave type should be filled in it's
respective date which excludes "Sat, Sun and Holidays (Holidays list is
displayed at A1:M1) ". After this L-S-D, L-E-D, Type cell values need to be
cleared which followed by fillin color with Red for CL cells and Yellow for
SL cells.

Does any one help me it would be great.

Advanced Thanks,
Vinod