Using Multi Conditional formats for a calendar

Hello all,

I have a excel sheet which allows me to select a rep in cell G2 and displays all the selected reps info in sheet2. I have a excel calendar in Sheet3. I have a legend in Sheet2 with diffenert colors to represent different codes the reps have used that day. What I want to do is make conditional formatting rules to use the different colors in my legend.

For example:

If I select a rep: and on 9/1/10 he had a T for Tardy
I want the color Orange to show on 9/1 on the calendar.
If they have times greater than 5 minutes then I want the color to show

I have tried to make formulas but I have had little success. I tied to use a named range in Sheet2 to try to help me but all I can do is find the dates a rep used.

Here is my formula:

=NOT(ISERROR(MATCH(A3,RepDates,0)))


Thanks