• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Event Colour and Description in Excel 2016

Roger120

New Member
Need help Please with Calendar & Activity planner that I downloaded for ms excel 2016. How do I add more colour and events to Special so that it, will automatically show up on the calendar with the Notes displayed as well. On the Daily Sheet it has the following headings Date: Special? Notes Example Date: 10 September Special? Birthday Notes: Roger, Date: 27 March Special? Church Notes: Soup Drive. This is what i want to be displayed on calendar.

On the Full Sheet the Special event only has 3 colours.

< Important

< Anniversary

< Vacation or Holiday

I need to add 14 Colours with the notes discription
 

Attachments

  • 2024-calendar-with-daily-planner.xlsx
    109.9 KB · Views: 3
Last edited:

Roger120

Please reread Forum Rules
Especially How to get the Best Results at Chandoo.org
 
On the Daily workseet, unhide hidden columns and change the lookup grid to this:

AliGW on MS365 Beta Channel (Windows 11) 64 bit


N
O
P
5
Importanti
1​
6
Anniversary¦
2​
7
Holiday=
3​
8
Vacation=
4​
9
Birthday
=
5​
10
0​
6​

Sheet: Daily

Then update:

Named Range - DayTypes needs to end wth D9 (this is for the drop-down list).
Conditional Formatting - make the first rule an OR rule and add D9 to it (this is for the icon colour).

Apply this process to adding the other specials you need.
 

Attachments

  • Roger120 2024-calendar-with-daily-planner CHANDOO AliGW.xlsx
    109.9 KB · Views: 3
Please let me know how you got on with this - some acknowledgement would be nice. Thanks.
 
Hi there thanks for the help but i only learned excel by my self. Not sure if what i did is incorrect.
If you look at January you will see that the colours do not work properly and that the note does not appear on calender.
 

Attachments

  • Roger120 2024-calendar-with-daily-planner.xlsx
    109.8 KB · Views: 1
What do you mean about the note not appearing on the calendar?

Colour-wise, you haven't set up the conditional formatting for the colours, so that's no surprise.
 
Hi sorry i do not know how to set conditional formatting at all. I have never done any formatting as i do not understand it at all. maybe i must stick to pen and paper. i have add an example page so that you can see what i mean. Again sorry for you having to put up with a dum persone.
 

Attachments

  • Roger120 2024-calendar-with-daily-planner.xlsx
    113.7 KB · Views: 1
OK - the monthly calendar is not designed to show items from the daily list, but that can be done. However, I need to know your Excel version.

I can also explain to you how to set up the conditional formatting, but I am not going to do it fo you for all 14 colours.

How does this sound?
 
OK - with 2016 it's not going to be as straightforward. I'll have a think and get back to you, maybe tomorrow.
 
Back
Top