Time is a vital resource that every company treasures and tries to transform into a gain. When choosing document management software, take note of a clutterless and user-friendly interface that empowers customers. DocHub delivers cutting-edge tools to maximize your document managing and transforms your PDF editing into a matter of one click. Hide Symbols into the Condition Report with DocHub to save a ton of time and improve your productiveness.
Make PDF editing an simple and easy intuitive operation that helps save you plenty of valuable time. Effortlessly change your files and send out them for signing without having adopting third-party software. Focus on pertinent tasks and improve your document managing with DocHub right now.
in this video Im going to show you how you can use your own symbols and traffic light type of color coding to bring attention to tasks that are past your deadline were going to do this using a combination of symbols and conditional formatting in this example I have my project time plan I have my tasks on the left hand side my start date the number of working days and using the work day function Ive calculated the end date so if you miss that video Im going to put a link to it in the descriptions below now what I want to do is take this one step further and I want to add symbols here together with conditional formatting to give me an indication on how I met have a completed these tasks which tasks am i behind on based on todays date and which tasks are upcoming and in the future and I still have time for so I want to implement three different sets of symbols and what I need is todays date so every time I open this workbook I want Excel to put in todays date and thats just the fo