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
Bookmarks