I have a day schedule recorder with each row of the sheet dedicated
to each colleagues of mine (total 35 colleagues)

I dedicate each sheet for one month with columns like Colleague name,
FromDate and Todate for each category (4 Categories like: Business
trip, Holidays, Internal Meeting, Vaccation)

When I enter FromDate to ToDate on a row of a colleague, the cells in
that purticular row should be coloured based on the name of the
Category for that period

I am pretty sure, it is confusing, it would be helpful if any one can
advice me how to upload my file for the rest of the group mates can
play around

I appreciate your helps