Forum Discussion
Solved
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
Dear Sir
Thank 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
Thank you very much.It works very good
Dear Sir
Kindly check :-In the year 2021 it reads Jan.3 ,2021 as shift change date but it should be jan 2, 2021.
Hi George,
I've fixed this issue in the attached file.
Regards