CONDITIONAL FORMATTING Articles: Excel and Google Sheets

When working with an excel worksheet there are times when we might be required to split the content of an excel workbook into multiple workbooks based on a given column. This might be due to various reasons. This makes learning how to split excel sheets a very important skill. Note...

Google Sheets conditional formatting is used to highlight the cells or rows based on condition(s) with the help of built-in rules and custom formula. Mostly, we apply Google Sheets conditional formatting based on another cell value using custom formula rule by comparing it with data set values with the help...

We can combine and center the contents of selected multiple cells inside a new and larger cell with the merge and center shortcut in Excel. When cells are merged, only the content of the upper-leftmost cell is preserved. “Center” implies that it allows for alignment of cell data to be...

Excel now supports millions of rows. It is easy to get lost working with large datasets to figure out the meaning of the values. Repeating header rows can help us with this problem. In this tutorial, we will learn how to keep the top line visible in Excel. Excel Repeat...

We can insert a total row in Excel by clicking the Design tab. With the Total row in our table, we can calculate several parameters automatically like average, maximum amount, minimum amount, etc. This tutorial will guide all levels of Excel users on how to use total rows in Excel....

Excel's IF function allows you to perform a logical test on your data and return one value if the result is TRUE and another if it is FALSE. There are a variety of ways to use the IF function, some more complex than others. This is a list of the...

When you want to apply formatting in Excel based on certain criteria, it's called Conditional Formatting. This list of in-depth tutorials will help you find the answers you need so that you can learn and apply this useful function.  If you can't find what you're looking for or need answers...

Conditional formatting is one of the most useful functions of Excel. This step by step tutorial will assist all levels of Excel users in conditional formatting two cells that are not equal. Example 1 Figure 1. Setting the data This data refers to the total and obtained GPA of students....

We often want to enhance the layout and format of our pivot tables by using Conditional Formatting.  This step by step tutorial will assist all levels of Excel users in working with a pivot table that has conditional formatting, and learning to solve some common problems associated with it.  ...

Excel Conditional Formatting can be used to match values in different cells along with reconciliation of data. Final result is as follow: Figure 1 - Final Result Our data-set show readings extracted from computer system and values manually note down. Our goal here is to check if values extracted from...