Editing spreadsheet is fast and simple using DocHub. Skip installing software to your laptop or computer and make changes using our drag and drop document editor in a few easy steps. DocHub is more than just a PDF editor. Users praise it for its ease of use and powerful features that you can use on desktop and mobile devices. You can annotate documents, make fillable forms, use eSignatures, and deliver records for completion to other people. All of this, combined with a competing price, makes DocHub the perfect decision to cover up light in spreadsheet files with ease.
Make your next tasks even easier by converting your documents into reusable web templates. Don't worry about the safety of your records, as we securely keep them in the DocHub cloud.
in this video we are going to learn how to highlight the row based on sell value in Microsoft Excel here in the example I have created a invoice tracking table and uh in this status column if I put here PID then you can see the row row is highlighted by blue color automatically similarly if I put here P then it is auto highlighted by blue color so in this video we are going to learn how to do this in Microsoft Excel so first of all here I removing this uh conditional formatting by going to the clear rule from selected sales and now there is no more conditional formatting used so when I put here paid then it is not highlighted so to do this in Excel first of all we have to select the data in this way then go to the home menu and then go to conditional formatting then here we have to go to new rule option and the new formatting dialog box will open and here we have to select the option which is use a formula to determine which sell to format then go to the formula ribon and uh write a fo