Hi,
Is there a way to highlight today on the Calendar? There is existing code to put borders around the days on the calendar so maybe that code could be altered?
Thanks for help
Hi,
Is there a way to highlight today on the Calendar? There is existing code to put borders around the days on the calendar so maybe that code could be altered?
Thanks for help
Select all cells in calendar (D4:J39) and in Condtional Formatting
formu;a;:
Set fill to desired colour=D4=TODAY()
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Thank you. Is it possible to only highlight the area inside the border area of the day number? I wish there were extra columns for the days so it would have more flexibility but it does not.
Not with CF - the borders around the numbers are text boxes, not cell borders. Might be possible with VBA.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Yes I agree it probably would need VBA to do it.
See attached where day is highlighted in RED with BOLD font: will this suffice?
To use VBA, you will need a macro to execute when the workbook is opened as this is only "trigeer" of a macro I can think of.
Last edited by JohnTopley; 09-29-2023 at 11:16 AM.
So it's not possible to have a color filled inside the number box?
How about with your original answer highlight rule and shade the part outside of the number box the same color as the background?
You cannot shade part of a cell so the only realistic option is as per my last solution. Any shading of the shape will simply hide the underlying text i.e the date.
All this is very cosmetic and is it really worth the effort?
Probably too much involved. Another possible option to have more flexibility would be to have 2 columns for each calendar day. I tried this before by inserting columns but it messed up the appointment codes.
To do what you want, you really need a TEXTBOX shape which will allow both colouring of the background and the entry of text
A lot of "pain" for no real "gain" (IMHO).
If I insert columns to have the flexibility thus not needing the code for textboxes and also not needing the formulas for holidays and occasions list on the right could you help adjust the appointment codes?
I would need to see exactly what is involved before committing any time: you know my view from post #11 on continuing this type of work!
You cannot just randomly insert extra columns as this throws out all formula and VBA!
I do respectfully suggest you put your time to ensuring that the BUSINESS aspects are working correctly (if this has not already been done!) rather spending time on these cosmetic changes.
I inserted columns so that each day has a border.
The first issue I see when clicking on appointment the information goes in column M but needs to go in column T
Last edited by billy60; 09-29-2023 at 12:21 PM.
Okay I just need one bit. I was able to get everything to function except for displaying a new appointment in the calendar. It saves the new appointment "bob" but it isn't being put in calendar day 9/1 as a shape like the other appointments.
Okay thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks