How to set the cell color to change as the data changes？

1. Open the table in WPS Office, select the cells that you want to set. 2. Click Home → Conditional Formatting → Highlight Cells Rules. 3. Select one of the rules as you need. Here we select Equal to for example. Fill a "5" in the text box, and select Light Red Fill with Dark Red Text. Then click OK. In the same way, we set "6" as Yellow Fill with Dark Yellow Text, and "7" as "Green Fill with Dark Green Text". 4. When the data in other cells is changed to 5, the changed cell will becom....

How to convert Word to JPG/PNG/BMP/TIF in WPS Office

Welcome to WPS Official Academy to check the contents of how to convert Word to pictures(JPG/PNG/BMP/TIF) in WPS Office. You are sure to master the converting skills after reading this tutorial! · Steps to convert Word to JPG/PNG/BMP/TIF in WPS Office1. Open your Word file.2. Navigate to the Tools tab, and click Export to Picture to pop up a dialog. 3. At Export Type, you can choose By Page or Long picture.By Page: To export the Word file as pictures.Long picture: To export the Word fi....

Compare two excel files for differences in WPS Office Excel

Welcome to WPS Official Academy to check the contents of compare two excel files for differences in WPS Office Excel. We often need to compare the data from two different excel files, but it would be troublesome to compare each item one by one with naked eyes. So how can we compare two excel files for differences in a quick and easy way? Let’s have a try step by step. Here we take two tables of employees performance appraisal for example. We can find the two tables are inconsistent wit....

Easy steps to crop PDF file in WPS Office

Are you ready to master easy steps to crop PDF file? After learning this WPS free tutorial, you will be advanced from a beginner in WPS PDF. Sometimes we may need to crop the PDF file to make it look better or remove the redundant content. WPS Office provides the Crop Page function, allowing you to crop PDF files quickly. · Steps to crop PDF file in WPS Office1. Open your PDF file in WPS Office.2. Head to the Edit tab, and click Crop Page to enter the cropping mode. 3. Here are four bu....

How to reduce size of PDF in WPS Office

Are you wondering how to reduce the size of a PDF file when printing? WPS Academy is here to introduce you to a quick and practical method of changing Page Size. · Quick steps to reduce size of PDF in WPS Office.1. Open your PDF file in WPS Office.2. Click the Menu button in the upper left corner > Print.3. In the Page Setup area, choose the desired size at the Page Size drop-down menu. Here we choose A5 for demonstration.4. Then click Print to save the settings. Note: No change can b....

Compare two sheets for differences in WPS Office Excel

Are you ready to master how to find differences between two sheets in WPS Office Excel? After learning this WPS free tutorial, you will be advanced from a beginner in WPS Spreadsheet. Sometimes we need to compare two worksheets and find out the differences between them but you’ll feel dizzy to compare each item one by one. At this point, the View Side by Side and Manage Duplicates function can help a lot. Let’s have a try step by step.Here we take two performance appraisal sheets (Jan....

How to split PDF quickly in WPS Office

Are you ready to master how to split PDF quickly in WPS Office? After learning this WPS free tutorial, you will be advanced from a beginner in WPS PDF. · Steps to split PDF quickly in WPS Office.1. Open the PDF file you need to split.2. Go to the Page tab > Split PDF. 3. Select the PDF file to split.4. Set the Page range, and set the splitting method at Split by.5. Set the location to save the split PDF file at Save as location.6. Click Split. With these steps, you are able to split P....

How to make a reference page for a resume in WPS Office Word

When coming across an ideal job opportunity, are you still playing the role of an outsider because of the deficiency in resume making? WPS Academy will provide a free tutorial that explains how to make a reference page for a resume in WPS Office Word in detail, assisting you in landing an interview. lWhat is a reference page for a resume in WPS Office Word?A reference page, also a reference list, is a document providing the contact and background information on professional references,....