Editing excel is fast and simple using DocHub. Skip installing software to your computer and make adjustments with our drag and drop document editor in just a few fast steps. DocHub is more than just a PDF editor. Users praise it for its ease of use and robust capabilities that you can use on desktop and mobile devices. You can annotate documents, generate fillable forms, use eSignatures, and email documents for completion to other people. All of this, combined with a competing price, makes DocHub the perfect option to blot out cross in excel files effortlessly.
Make your next tasks even easier by converting your documents into reusable web templates. Don't worry about the security of your records, as we securely keep them in the DocHub cloud.
hey everyone welcome to the otoscope excel video blog where I offer up my favorite excel tips tricks and hacks today I want to talk about conditional formatting conditional formatting in Excel lets you automatically format a cell based on rules one question I see a lot is how do you format one cell based on another cells value and thatamp;#39;s what I want to cover today the data Iamp;#39;m working with consists of invoices for each invoice I have the account number of the customer the amount thatamp;#39;s due the date of the invoice the date that itamp;#39;s due and the days outstanding which is the days since the invoice date my payment terms for all sales are 60 days this means all of the accounts that are past 60 days outstanding are past due I need to collect payment on delinquent accounts and it would be awesome if I could format account numbers in column a based on the days outstanding number in column E let me go to the second tab to show you what this is going to look like