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 easy steps. DocHub is more than just a PDF editor. Users praise it for its ease of use and powerful capabilities that you can use on desktop and mobile devices. You can annotate documents, generate fillable forms, use eSignatures, and email records for completion to other people. All of this, put together with a competing cost, makes DocHub the perfect decision to cover up highlight in excel files effortlessly.
Make your next tasks even easier by converting your documents into reusable templates. Don't worry about the security of your records, as we securely store them in the DocHub cloud.
hello and welcome to conditional formatting based on another cell in Microsoft Excel my name is Jeff Iamp;#39;m glad youamp;#39;re here letamp;#39;s just jump right in so itamp;#39;s relatively straightforward in Microsoft Excel to apply conditional formatting to a cell based on the value of that cell okay what weamp;#39;re going to do is weamp;#39;re going to apply conditional formatting to some cells based on the values in other cells okay so letamp;#39;s just go ahead and flip over to excel now what weamp;#39;re going to try to do is format this range based on the value of these cells okay so as an example what would be pretty straightforward is to format this status column based on the status column values so we would go to conditional formatting highlight cell rules equal to and we would say if this cell value is equal to open then apply whatever format you want weamp;#39;re going to go with green and click ok that is applying conditional formatting based on the value of