Forum Discussion
excel date color
I change this calendar by changing B1.
Result is good expect color of highlighted dates.I want color of highlighted dates in column A and in other columns same .
Thank you very much.It works very good
Hi George,
The worksheet has complicated and unnecessary array formulas!
Because of this, it's too slow and takes a lot of time to calculate!
You can do it all in another way easier, faster, more efficiently, and more flexible so that you are not limited to the year 2020.
I've updated the worksheet with a better approach and applied the conditional formatting rule to the other columns.
Please find the attached file.
Hope that helps
- Dear SirThank you for your help.Highlighted cells in column B are dates of shift change (Every 6th day).First shift change was on Jan 3, 2018 ,then Jan 8,2018, and so on continuously.This is why I formatted column B .In Feb 2018 dates are different and in march they are different and so on.It is different in the year 2020.Dates are different in month-wise and year-wise. When you select any year the days in that year should be highlighted same as in column B.
Hi George,
This can be done, but you need to a separate conditional formatting rule for each month and supported with a logic to deal with leap years.
I've done for you!
Please find the attached file.
Regards,
Haytham
