Editing WPS is fast and simple using DocHub. Skip downloading software to your computer and make alterations 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 efficiency and powerful features that you can use on desktop and mobile devices. You can annotate documents, generate fillable forms, use eSignatures, and send records for completion to other people. All of this, put together with a competitive price, makes DocHub the perfect decision to tack comma in WPS files effortlessly.
Make your next tasks even easier by turning your documents into reusable templates. Don't worry about the safety of your records, as we securely store them in the DocHub cloud.
Take this table as an example. We can use the formula to set the conditional formatting by ourselves and mark the finished projects. Select the cell range A2:C22, and get into the amp;quot;Homeamp;quot; tab. Click the amp;quot;Conditional Formattingamp;quot; drop-down button, and choose the amp;quot;New Ruleamp;quot; option. In the pop-up dialog, we choose the amp;quot;Use a formula to determine which cells to formatamp;quot; option. In the amp;quot;Format only cells withamp;quot; edit box, enter the formula amp;quot;=$C2=amp;quot;Finishedamp;quot; amp;quot;. The absolute reference has been added to the column label to prevent the data in column C from moving. The row number does not add an absolute reference so that it will change into $C2, $C3, $C4 with the selected data area. Then, we click the amp;quot;Formatamp;quot; button to open the amp;quot;Format Cellsamp;quot; dialog, switch to the amp;quot;Patternsamp;quot; option, select a favorite fill color, and click