# CONDITIONAL FORMATTING Articles: Excel and Google Sheets

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

### CONDITIONAL FORMATTING

Learn How to Use SUMIFS in 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...
How to Use the SUMIFS Function in Excel
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...
Change cell color of top 10 values in a column
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...
How to Copy the Conditional Format to Another Cell
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...
Learn How to Fill a Cell with Color Based on a Condition
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...
Learn How to Apply Conditional Formatting Based on the Value of Another Cell
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...
How to Apply Conditional Formatting to Blank Cells
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...
How to Use Conditional Formatting to Change Cell Background Color Based on Cell Value
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...
Learn How to Copy and Paste Conditional Formatting to Another Cell
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...
How to Use Conditional Formatting to Highlight Cells Less Than or Greater Than Some Value
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...
1 2 5 6 7