Dear Sir/Madam,
I propose that, there can be a formula based excel sheet, rather than a macro.
I have uploaded a sample in my profile as "sample excel sheet", can you please go through it?
You can select shift in drop down, and if you select night, next 2 cells become grey.
Hope to get a positive response from your side :)
Thanks !
Regards,
D E W