In practice, it is sometimes necessary to compare the contents of two spreadsheets. With the exception of specialized Excel plugins that can be used for this purpose, the best way to achieve this is with the help of a formula in which we use the IF function or by using conditional formatting. In the text that follows, you will see how to compare the two tables, which are in two spreadsheets, and contain randomly generated numbers.
When we want to give our opinion about a product, we are often able to evaluate it by assigning a certain number of stars. Our rating updates the previous state, and the product score is always a number. How do you calculate how many total stars a product should have based on the score number? There are several ways to do this in Excel, and one of them is by applying the Conditional Formatting option.
When defining conditional formatting rules, sometimes there are more than one format, and we want one formatting rule to exclude another. In these situations, Stop If True option may be helpful. It is used in various ways, and one of the simplest is filtering the conditional formatting rules given by icon sets. Let’s see how this works!
I got an e-mail today from my wife who is a big cat lover. She says YouTube suggested her to watch the „Cat Icon Array Chart“ video. And since there is often a need to show the share of a value in a whole, using icon array chart, I decided to write a “recipe” that would teach you how to present data this way, without really using charts.
Conditional formatting is an option that has been gradually added to Table and Matrix visual. Now we can safely say that Power BI Desktop has almost everything we used in Excel to build the reports where we applied this option. As of July 2019, conditional formatting also supports icon sets, and in the text below you will be able to learn how to use all of these options.