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
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
Hello sir
jan 2, 2022 should be shift change but calendar shows jan 3 , 2022. Is it Possible to copy color of dates from column B according to date