You no longer have to worry about how to redo fact in WPS. Our comprehensive solution provides easy and fast document management, allowing you to work on WPS documents in a couple of moments instead of hours or days. Our service includes all the tools you need: merging, adding fillable fields, signing documents legally, inserting shapes, and so on. You don't need to set up extra software or bother with high-priced applications demanding a powerful device. With only two clicks in your browser, you can access everything you need.
Start now and handle all different types of forms professionally!
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