Have you ever had trouble with modifying your WPS document while on the go? Well, DocHub comes with a great solution for that! Access this cloud editor from any internet-connected device. It allows users to Revise formula in WPS files quickly and anytime needed.
DocHub will surprise you with what it offers. It has robust functionality to make whatever updates you want to your forms. And its interface is so intuitive that the whole process from beginning to end will take you only a few clicks.
After you complete adjusting and sharing, you can save your updated WPS document on your device or to the cloud as it is or with an Audit Trail that includes all adjustments applied. Also, you can save your paperwork in its initial version or turn it into a multi-use template - complete any document management task from anywhere with DocHub. Subscribe today!
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 Home tab. Click the Conditional Formatting drop-down button, and choose the New Rule option. In the pop-up dialog, we choose the Use a formula to determine which cells to format option. In the Format only cells with edit box, enter the formula =$C2=Finished . 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 Format button to open the Format Cells dialog, switch to the Patterns option, select a favorite fill color, and click OK to complete the settings. In this way, when the cell content of column C is equal to Finished, the conditional formatting weve just set will be applied. If we want to clea