CONDITIONAL FORMATTING Articles: Excel and Google Sheets

All resources related to CONDITIONAL FORMATTING for Excel and Google Sheets.
All articles CONDITIONAL FORMATTING

CONDITIONAL FORMATTING

How to split one excel cell into multiple sheets – Excelchat
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...
How to Apply Google Sheets Conditional Formatting Based on Another Cell – Excelchat
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...
How to merge and center cells in Excel – Excelchat
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...
How to Repeat Header Row when Scrolling in Google Sheets and Excel – Excelchat
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...
How to Insert Total Row in Excel
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 IF Function Examples – IF THEN, IF with Multiple Criteria, IF ELSE
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...
Excel Conditional Formatting Examples – SUMIFS, Highlighting Cells, Copy-Paste
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...
Here’s How You Can Use Conditional Formatting If Two Cells Are Not Equal
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....
Working with a Pivot Table that Has Conditional Formatting
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.  ...
How to Apply Conditional Formatting Between Sheets in Excel
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...
1 2 6 7