Forum Discussion
Help with data and visuals
I hope i can explain this right, i have data that shows 3 things: person, start date and end date: now i need excel to take this information and represent it as the following in the month tr...
With Power Query + Conditional Formatting
With data in the green table > Right-click in the timeline > Refresh
- Hope you don't have too many names as 2 Conditional Formatting rules are required per name/row in the timeline
- If you see twice (or +) the same name within the same week, this means 2 (or +) tasks/assignments are planed that week. Ex. with Abe in the picture
Sample available https://1drv.ms/x/c/1cd824d35610aacb/EUDMSudf-OVMlXyk2cjRbe0Ba4uY6DZ0PmzEg9xhSicP8Q (to download)