Editing excel is fast and straightforward using DocHub. Skip downloading software to your PC and make adjustments using our drag and drop document editor in a few fast steps. DocHub is more than just a PDF editor. Users praise it for its convenience and robust features that you can use on desktop and mobile devices. You can annotate documents, make fillable forms, use eSignatures, and email documents for completion to other people. All of this, put together with a competing price, makes DocHub the ideal choice to negate light in excel files with ease.
Make your next tasks even easier by converting your documents into reusable web templates. Don't worry about the protection of your data, as we securely store 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