CONDITIONAL FORMATTING Articles: Excel and Google Sheets

Google Sheets is similar to Excel and uses many of the same functions. Assuming you want to sum a range of values and have some criteria to either include or exclude, you can use the SUMIFS function.  How to Use SUMIFS in Google Sheets If you want to learn how...

The SUMIFS function in Excel sums data that fulfills multiple criteria. It is one of the most widely used math and trig functions to add data based on multiple conditions. In this tutorial, you will learn how to use SUMIFS in Excel. The SUMIFS Function in EXCEL Syntax of the...

Changing the cell color based on a value is an effective way to visualize data. Excel has a built-in feature that lets you change the cell color based on value. It’s called Conditional Formatting. Conditional formatting in Excel enables you to highlight cells with a certain color, depending on the cell's...

Conditional formatting is a feature of Excel which allows you to apply a format such as colors, icons, and data bars to a cell or a range of cells based on certain criteria. There are many ways to use Conditional Formatting, and you can also copy that format to another...

There are several ways to color format cells in Excel, but not all of them accomplish the same thing. If you want to fill a cell with color based on a condition, you will need to use the Conditional Formatting feature. Fill a cell with color based on a condition...

If you want to apply conditional formatting based on the value of another cell including text or number or date etc., then this can be achieved by creating a rule in conditional formatting using a custom formula. Example of conditional formatting based on the value of another cell In the...

We can use the conditional formatting approach for “cells that do not contain any value or for blank cells”. This step by step tutorial will assist all levels of Excel users on how to apply conditional formatting to blank cells. Apply conditional formatting to blank cells The aim of this exercise...

Changing the color of a cell might seem simple enough, but what if you wanted cells to be a particular color based on certain criteria? In these cases, you would use conditional formatting to change your cell's background color. Basic cell color formatting Did you know that you can change...

Conditional formatting allows you to copy the format of a cell to another cell or range of cells. You can easily copy the conditional formatting rule applied on one cell to other cell or range of cells by using one of the following approaches. Copy and paste conditional formatting to...

If you want to highlight cells based on a value as criteria, then you can use conditional formatting by using a built-in rule and a custom formula. This tutorial will show you how with several illustrated examples.  Use conditional highlighting to highlight cells less than or greater than a value...