WPS Office

Free All-in-One Office Suite with PDF Editor


Edit Word, Excel, and PPT for FREE.


Read, edit, and convert PDFs with the powerful PDF toolkit.


Microsoft-like interface, easy to use.

Free Download

Windows • MacOS • Linux • iOS • Android


Conditional Formatting for data virtualization

Uploaded time: November 3, 2021 Difficulty Beginner

Conditional Formatting for data virtualization

Conditional Formatting for data virtualization

Do you know how to virtualize datawith the Conditional Formatting function? The worksheet presents the data of 'Likes to views ratios'.

Today's tutorialwill take this sheet as an example for data virtualising.

Select the cell range B2:B10. Go to Home and click Conditional Formatting. Next, choose Data Bars and then the red Gradient Filloption. After that, we can see the data virtualized with red bars.

Although the data in cell B13 is 66.42%, as we can see, the data barfills the whole cell. This is because WPS Spreadsheet considered 66.42% as the largest proportion.

Select the cell range B2 to B10 and choose Manage Rules in Conditional Formatting. In the popup, click Edit Rule to open another dialog Edit Formatting Rule.

Next, choose Number respectively in the category Minimum and Maximum.

Then, enter '1' in the Maximum input box. Here '1' refers to '100%'.

Finally, choose No Borderunder the Border category and click OK.

That's all for the tutorial on virtualizing data. Did you get it?

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.