Forum Discussion
Formatting cells based on certain date function.
With your permission,
if I can recommend. It can help us all if you upload an Excel file (without sensitive data), no picture. Even if it is said that a picture can say a thousand words, it is certainly not in the case of Excel, on the contrary in some cases.
You could get a precise solution much faster with a file (w/out sensitive data).
This would also be a blessing for all of us, as we can understand the problem much better, a win-win situation for everyone.
*Knowledge of Excel version and the operating system is a must have if you want to proposing a reasonable solution (Example: office version e.g. 2016 or 2019 or 365 web or 365 pro, etc) and your operating system (e.g. Win10 (2004), Win 10 (1903), Mac, etc.).
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
NikolinoDEPlease see the attached excel sheet.
All cells with Black colour is day off and rest of the colour coded cells are for specific tasks. I wish to get the colour coding for the rolling off days, if possible. As I explained earlier the day off will keep changing from week to week. And on every 5th week day off will start on Friday for that week followed by Monday of the next week.
Will it be possible to get that sorted with the dates/days from the first two cells?
Thank you for your time and help.