Google sheets are the warehouse of massive data in a mannered format. Conditional Formatting provides you the insight that you can take just by a glance on your sheet.
It allows you to highlight the cells that meet up certain criteria, which provides you a better understanding of your spreadsheet just at one glance and helps you to create a spreadsheet that is easier for everyone to read and the understand the message it intends to deliver. this also provides a great way to track goals, giving you the indications specifically in all the areas how you are progressing and you can have the idea in which area you need to improve or make it better.
It allows you to change different aspects of cell in terms of the background of the cell or style of the text, the way you define. The rule you set is in the format of IF/THEN. E.g.: “If cell B1 is empty, then change the background color of the cell to green.”
The best reason for using the conditional formatting is that you can easily highlight the duplicates that generally generates if you are dealing with a large set of data. Like if there are two duplicate cells or duplicate rows then they both will get format as per the IF clause, so that way you can easily check the duplicates as well as format your spreadsheet to make sure it gives no errors due to duplicates.
How to use Conditional Formatting in Google Sheets:
Select a range
Select a range (columns, row or cells) and then click Format>Conditional Formatting. By clicking this, a toolbar will pop up on the right side of the screen.
If you are dealing with a large amount of data click Format>Conditional Formatting and enter your specified range on the right side in the range tab.
Select a style
The moment you start applying or I should say, the if cause the cells will change its aspects. Under Formatting style click Default, then you can opt for the design you want and if you don’t want anyone of them then also you can customize your designs.
Once you start to format your cells then, you have to apply an if clause based on which the cells will get format. You can enter the range or the cell you wish to change on the range section and then you can set the IF formula and then at the same time and this way your cell will get formatted. Once you are done with this just click the Done button and the conditional formatting is done as per your metrics.
How to Use IF Formula in Google Sheets:
You can also remove the duplicates from your spreadsheet using IF formula which is being widely used. It returns the value through an if-then-else logical construct. First, it evaluated the given logical expression, then if it is true it returns the first value and if it is false it returns the second value.
The syntax is:
IF(logical_expression, value_if_true, value_if_false)
logical_expression: a reference cell containing the expression based on which it needs to be evaluated to either TRUE or FALSE.
value_if_true: the value to be returned if the expression evaluated is TRUE.
value_if_false: the value to be returned if the expression evaluated is FALSE.
There are other formulas which can be used to remove duplicates like the IF formula. We have covered how to remove duplicates from Google Sheets with UNIQUE and COUNTIF formula on one of our previous blog post. If you enjoyed this blog post on Google Sheets here are other articles in our Google Sheets Cheat Series:
We hope you found this article useful. Use our guide Free Keyboard Shortcuts: Spreadsheet Secrets and watch yourself transform from a Google Sheets newbie to a ninja in no time! Save your copy and add the shortcuts that you discover to quickly refer back anytime you need. Stay subscribed to Wyzebulb Blog for more blogs and articles on Automation, Marketing, and Productivity!
No Comments