Search results

Thank you for all the support!!! Best Regards, Luis

Hi Bosco, No... What i really need is the attached file working with your conditional format on my computer (Portuguese Date Format that comes from "Windows Control Panel). That date location you pointed out on your last post was what I changed the first time, when I said the file still...

Hi Bosco,, I was not able to detect where to change it to my date format (Portuguese format). Could you please give me directions, and if not asking to much explain by words the conditional format formula. Thanks!

Hi again, sorry guys, I confirm also that it works fine changing to British Format at Windows Control Panel (I didn´t change it correctly at the first time). Will try to adapt formula to my date format. Thanks again!

Hi Bosco, no that doesn´t work either. Super strange, cause it works for some of the months. I tried to use a month/year calendar model that I already have on the file and it works ok, now I have to adjust the conditional format formulas. If you find the solution please post it. If I cannot make...

The error comes from the calendar itself. If you are not seeing it what can it be?

I´m still getting the error, on months feb, abr, may aug, set out dec

It´s the same I didn´t touch it. I´m using excel 2016.

Hello Bosco, Thank you very much for your inputs! Excellent, month / year / worker option! But I´m getting an error for some months when updating the calendar (pex: Feb). I still didn´t find where...

Hi Peter, thank you very much for your help! You made it! I thought it was much easier. Visually I like it, but it is very tricky... Like Chihiro, do you recommend another approach for a similar result?

Hi again, thanks for your feedback. I´ve seen your file, it´s very close but i still didn´t make it. Could you please take a look to my file structure. Thanks

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...