User Profile
EGrant475
Copper Contributor
Joined 10 months ago
User Widgets
Recent Discussions
Identifying different sections to be completed in a work document for multiple people?
I don't know if there is a way to actually do this, but I have a word document that needs to be filled out by 3 separate individuals from different departments (eg: sales/marketing/operations). Some bits to be filled are fields in a table, and others are simply typing a response below a question. I am looking for a way to easily show the individuals which sections they need to complete, perhaps automatically highlighting the fields based on a department selection in a drop down? Does anyone have an idea on how to achieve this? A point to note is that this will be an offline document that is only accessible by one individual at a time. If anyone can how to achieve my vision or come up with an alternative solution that would be great!Creating a chart/graph on the total of highlighted, conditionally formatted cells?
I have a series of data in a table, example below: It is formatted so that if the completion date is more than 3 months before the deadline, it highlights green, and less than 3 months highlights red. I need to create a bar chart and a pie chart to show just the number of red and the number of green. How would I achieve this? Thanks,
