Luis Silva
New Member
Hello, I´m making a holiday planner for different workers. In monthly worksheet I insert all the different occurrences (pex: x-present, h-holiday, etc), and I use conditional format to highlight the cells with different colors. What I need is a yearly calendar view for each different worker, with dropdown/data validation to choose the worker and after a year calendar that replicates the conditional format used on the monthly worksheet for that worker. Can someone give a help on how to do this, the formula to use in the conditional format, or point out a file that I can see. Thanks