You can’t make document modifications more convenient than editing your WPS files on the web. With DocHub, you can access tools to edit documents in fillable PDF, WPS, or other formats: highlight, blackout, or erase document elements. Include text and pictures where you need them, rewrite your copy completely, and more. You can save your edited record to your device or share it by email or direct link. You can also transform your documents into fillable forms and invite others to complete them. DocHub even has an eSignature that allows you to sign and deliver documents for signing with just a couple of clicks.
Your records are safely kept in our DocHub cloud, so you can access them at any time from your PC, laptop, mobile, or tablet. Should you prefer to use your mobile phone for file editing, you can easily do so with DocHub’s application for iOS or Android.
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