A1:G12 is a calendar (VBA code from microsoft) / A15:A25 is name field /
B15:B25 is start date field / C15:C25 is End Date field.

1. I want the dates between start/end to highlight if an employee wants
those as vacation days. (i can figure this out if only one employee takes a
vacation but not for several employees within the same month ie max 3
conditional formats
2. Can i have multiple highlights if employee vacations have crossover dates
for ex: mike jan 2 - jan 5 and todd jan 4 - jan 8.

if you think something else would benefit me more pls let me know
thanks in advance