You no longer have to worry about how to shade comma in WPS. Our powerful solution provides straightforward and fast document management, allowing you to work on WPS documents in a few minutes instead of hours or days. Our platform covers all the tools you need: merging, inserting fillable fields, signing forms legally, placing signs, and much more. There’s no need to set up extra software or bother with pricey applications requiring a powerful computer. With only two clicks in your browser, you can access everything you need.
Start now and manage all various types of forms like a pro!
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