Have you ever struggled with editing your WPS document while on the go? Well, DocHub has a great solution for that! Access this cloud editor from any internet-connected device. It enables users to Omit highlight in WPS files rapidly and anytime needed.
DocHub will surprise you with what it offers. It has powerful capabilities to make whatever changes you want to your forms. And its interface is so easy-to-use that the entire process from start to finish will take you only a few clicks.
When you complete modifying 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 contains all modifications applied. Also, you can save your paperwork in its original version or convert it into a multi-use template - accomplish any document management task from anyplace with DocHub. Subscribe today!
Take this table as an example. This is a sales performance table. Now we want to add a red flag to employees whose sales are greater than or equal to $950 while giving warnings to under-performers with sales less than $700. So how can we do that? We can use conditional formatting. We can select the D2:D26 cell, then click the Conditional Formatting in the Home tab before choosing the Icon Sets option, and click the More Rules in the pop-up menu. In the pop-up dialog box, select the red flag in the drop-down list of the first icon, select Number in the drop-down list of Type, and input 950 in Value. Then select no cell Icon under the second icon, selectNumber under the drop-down list of Type, then input 700 in Value. Select a yellow exclamation mark under the third icon as a warning, and finally click OK. At this time, a small red flag will be put in front of cells with a sales volume greater than or equal to 950, and a yellow exclamation mark in front of cells