vba code - on click to copy format and paste to elsewhere the user wants

Am developing a better user experience. Looking for a solution for a set of code to allow user to click on a particular cell (which already has all the correct formatting) to copy the format of that cell to anywhere the user wants.

It would be better to describe the user experience with the attached sample file. Wanted to be able to design a code to allow user to say they want to take a few days off, they will first click on cell F177 to obtain the format, and then they will go can click the first day they want to start and then click on the last day of their leave period, Excel will then paste the format of F177 to all those cells in between. It also needs to be able to take both clicks on the same cell if the user wants to take only 1 day off. Is this doable? if yes, how cand I achieve this?

I know how to use the format painter myself. the design is targeting for those non excel users so their experience to submit a leave is just a few simple clicks and leave the rest to Excel to complete. the plan is to have Excel to create a log based on the user input and then when they click a 'submit' button, the file will be saved and be submitted via email to the manager for approval.