stylencia18
New Member
- Joined
- Aug 14, 2017
- Messages
- 31
Good afternoon!!!
I have data with a bunch of dates for different people in Excel (see below for sample). I wanted to highlight these dates on a calendar. I downloaded a template calendar and used conditional formatting to highlight the dates on the calendar for each person. My issue now is that I want to see the dates only for Marty. Then I want to quickly switch to the dates only for Amanda on the calendar. How do I do this? A pivot table? Slicer?
Marty 1/1/2015
1/2/2015
1/3/2015
1/4/2015
1/5/2015
Amanda 2/2/2015
2/3/2015
2/7/2015
2/8/2015
Wayne 3/2/2015
3/8/2015
(I have approx. 350 different people with dates associated with them).
I have data with a bunch of dates for different people in Excel (see below for sample). I wanted to highlight these dates on a calendar. I downloaded a template calendar and used conditional formatting to highlight the dates on the calendar for each person. My issue now is that I want to see the dates only for Marty. Then I want to quickly switch to the dates only for Amanda on the calendar. How do I do this? A pivot table? Slicer?

Marty 1/1/2015
1/2/2015
1/3/2015
1/4/2015
1/5/2015
Amanda 2/2/2015
2/3/2015
2/7/2015
2/8/2015
Wayne 3/2/2015
3/8/2015
(I have approx. 350 different people with dates associated with them).