Forum Discussion
dynamic excel calendar help pls
hi I saw a youtube to create a dynamic calendar the dates are using sequence, may I know how to have column D for text input Mon to Sun same for the rest of the columns I want to have one...
hi Rachel,
Thank you but what is HSTrack?
I notice that u Run the event A to F, if I want to pick from selected columns, not all the columns Text, how to as the real data is very big. Thank you
Thank you
HSTACK stacks columns horizontally.
e.g if you want to include column A and column F, you can use
=HSTACK($A:$A,$F:$F)
if you want to include column A, B and F, you can use
=HSTACK($A:$B,$F:$F)
hi Rachel,
Great it works.
. One last question, the text are display as a string of text, is there anyway to break it into next row
event -bold title
confirmed
XXX
add Status : the data fr the list?
Also anyway to color format the item by it Category? Thanks
Thank youI think you will have to change the "Dynamic Calendar" if you want to break event information into different rows.
I attached an example.
As for colouring, you can use conditional formatting to do that: