Hi all,

I am quite new to excel and have been using it more and more with my work. I have made a spreadsheet that has all of our work on it with their start and finish dates, within this there is also a calender. I want to be able to select the date and within the calendar have the right month be highlighted that correlates with the selected date. Along with this, I also want the highlighted cell in the calender to match the colours of the customer we are referencing to. 

TIA

​Hi all, I am quite new to excel and have been using it more and more with my work. I have made a spreadsheet that has all of our work on it with their start and finish dates, within this there is also a calender. I want to be able to select the date and within the calendar have the right month be highlighted that correlates with the selected date. Along with this, I also want the highlighted cell in the calender to match the colours of the customer we are referencing to.  TIA  Read More

​