Try this. I am not familiar with the terminologies of tombola or bingo as I don't play them. So if any of them is incorrect please change it. Su...
Hi Maruizio Since you already have a working copy of the game, why do you want to create another one? Sunny
Hi npr You did not add the holidays into your conditional formatting. Your formula : =AND($E9<=J$8,WORKDAY.INTL($E9-1,$F9,7)>=J$8,AND(...
Hi Maruizio I don't think I understand what you want and Google Translate isn't helping much either 🙂 Post a file with what you expect and hopeful...
Hi npr I think it is better you upload the file and explain which part is not correct. Please do not include sensitive data. Sunny
Hi Maurizio See if this is what you wanted. You will need to modify it to suit your requirements. Sunny
Hi npr My apologies. The formula should be Holidays!$E$6:$E$7. I think I forgot to change it back after testing with different dates. Sunny
Hi Frans You can see my 2nd formula. It should be easier to change even though it looks more complex than my 1st.
Hi Hava Nice to know it is useful to you. What Frans Visser meant was that I created a drop down list for you to choose instead of keying in. ...
Thanks Frans for your comments . Whether to work with variables (named ranges) or otherwise will depend on the project. For bigger projects I would...
Dear npr The formula is shown as Holidays!E6:E7 because I renamed the worksheet containing the holiday dates to Holidays otherwise the formula will...
Hi npr See if this is what you are looking for. I would suggest you create a dynamic range for your holidays. Sunny
Hi Hava See if this is what you wanted. Sunny
Hi Zubin Try this. Sunny
Hi npr To freeze the panels, do the following: 1) Select cell L16 2) From the ribbon select View - Freeze Panels - Freeze Panels If it is ...