You can’t make document changes more convenient than editing your WPS files online. With DocHub, you can access instruments to edit documents in fillable PDF, WPS, or other formats: highlight, blackout, or erase document elements. Include textual content and images where you need them, rewrite your form entirely, and more. You can save your edited file to your device or submit it by email or direct link. You can also turn your documents into fillable forms and ask others to complete them. DocHub even has an eSignature that allows you to sign and deliver paperwork for signing with just a couple of clicks.
Your documents are securely kept in our DocHub cloud, so you can access them at any time from your PC, laptop, smartphone, 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