Excel Pro for Calendar Formatting Enhancement
Budget: €8 – €30 EUR
I need an Excel wizard to refine my availability calendar. The Calendar is Google Sheets-derived and ought to be fairly straightforward for a skilled Excel user. The tasks include:
1. Date Formatting: Revise the date format from its current mm/dd/yyyy to dd/mm/yy. Your expertise in Excel functions and formulae will be key to achieving this seamlessly.
2. Color Coding: Reconfigure the colour of booking designations based on the occupant. I want a color-coding system involving red, blue, green, pale blue and purple. Your keen eye for design and detail, as well as your understanding of conditional formatting, will enable you to implement this effectively.
This engagement requires proficiency in MS Excel and Google Sheets. Familiarity with conditional formatting and date manipulation functions is absolute.
1. Date Formatting: Revise the date format from its current mm/dd/yyyy to dd/mm/yy. Your expertise in Excel functions and formulae will be key to achieving this seamlessly.
2. Color Coding: Reconfigure the colour of booking designations based on the occupant. I want a color-coding system involving red, blue, green, pale blue and purple. Your keen eye for design and detail, as well as your understanding of conditional formatting, will enable you to implement this effectively.
This engagement requires proficiency in MS Excel and Google Sheets. Familiarity with conditional formatting and date manipulation functions is absolute.