Conditional Formatting - Free Excel Tutorial

Conditional formatting based on another column in Google Sheets or Excel

September 17, 2022

In Microsoft Excel Spreadsheet or google sheets, conditional formatting is used to highlight any cell based on a predefined condition and the value of those cells. In the previous article, we described how to format a specific column or cell range based on another cell value in Excel or google sheets. In Excel or Google… read more »

Conditional Formatting based on Another Cell in Google Sheets/Excel

September 15, 2022

In Microsoft Excel Spreadsheet or google sheets, when you want to format a specified cell or cell range based on the value of a different cell, for example, formatting the first row based on the value of a cell in a single column, you can use the conditional formatting function to create formatting formulas. This… read more »

How to Highlight All Non-Blank Cells in Excel

July 24, 2020

Suppose we have a table with some blank cells, if we want to highlight all non-blank cells how can we do? Though we can press ctrl and pick each non-blank cell one by one, this way is very bothersome. We need a convenient way to highlight all non-blank cells immediately. Actually, we can implement this… read more »

How to Highlight Cells Based on Their First Letter/Character by Conditional Format in Excel

March 22, 2020

Sometimes we want to highlight some cells based on certain criteria, for example highlight all cells which the first letter is X, this requirement is quite commonly used in searching. Actually, to implement this function, you can highlight these cells by conditional format in excel. This function can help you quickly locate and highlight the… read more »

How to Remove Conditional Formatting on Blank Cells in Excel

September 3, 2019

This post will guide you how to remove conditional formatting if cell is blank in Excel. How do I skip conditional formatting for blank cells in Excel 2013/2016. Remove Conditional Formatting on Blank Cells Assuming that you have a list of data in range B1:B5, in which contain text values and blank cells, and have… read more »

Conditional Formatting Rows by Groups in Excel

August 26, 2019

This post will guide you how to apply conditional formatting for alternate row color based on groups in your worksheet in Excel. How do I alter row color by groups using conditioanl formatting in Excel 2013/2016. Alternating Rows Color by Groups Assuming that you have a list of data in range A1:B5, in which contain… read more »

How to Highlight Cell or Row If Date Is In Current Day/Week/Month in Excel

April 5, 2019

This post will guide you how to highlight cell if date is the current day or is in the current week or month in Excel. How do I highlight row if date is in current week or month with conditional formatting in Excel 2013/2016. Highlight Cell if Date is in Current Day/Week/Month Highlight Row if… read more »

How to Highlight Cells Greater Than a Certain Length in Excel

March 6, 2019

This post will guide you how to highlight a cell that contains more than a certain length using Conditional Formatting function in Excel. How do I highlight cells greater than or less than a certain text length in Excel. Highlight Cells Based on Text Length Assuming that you have a list of data in range… read more »

How to Highlight Dates Older Than 30 Days in Excel

January 21, 2019

This post will guide you how to highlight dates older than 30 days in Excel. How do I use conditional formatting to highlight if date is greater than 30 days old in Excel. How to highlight a row or cell if it’s older than x days in Excel. Highlight Dates Older Than 30 Days Assuming… read more »

How to Select Cells That Meet Certain Criteria in Excel

January 16, 2019

This post will guide you how to select cells that meet certain criteria in Excel. How do I find and select cells based on specific types of data in your worksheet in Excel. Select Cells That Meet one Criteria Using Go To Command Find Cells That Meet one Criteria Using Conditional Formatting Select Cells That… read more »

How to Highlight The Highest and Lowest Value in Each Row or Column in Excel

December 11, 2018

This post will guide you how to highlight the highest value in each row or column in Excel. How do I highlight the lowest value in each row and column with conditional formatting function. Highlight Highest Value in Each Row Highlight Lowest Value in Each Row Highlight Highest Value in Each Column Highlight Lowest Value… read more »

How to Change the Font Color Based on Cell Value in Excel

December 10, 2018

This post will guide you how to change the font color based on cell value in Excel. How do I color cell based on cell value using the conditional formatting feature in Excel. Changing Font Color Based on Cell Value Video: Changing Font color based on Cell Value Changing Font Color Based on Cell Value… read more »

How to Highlight Blank Cells in Excel

November 26, 2018

This post will guide you how to highlight blank cells in Excel. How do I use Conditional Formatting to highlight blank cells in Excel. Highlight Blank Cells with Go To Special Feature Highlight Blank Cells with Conditional Formatting Video: Highlight Blank Cells Highlight Blank Cells with Go To Special Feature If you want to highlight… read more »

How to Find and Highlight Duplicate Rows in Excel

November 20, 2018

This post will guide you how to find and highlight duplicate rows in a range of cells in Excel. How do I find duplicate rows in a range with a formula in Excel. How to find duplicate rows in two or three columns with Conditional Formatting feature in Excel. Find Duplicate Rows Only Find and… read more »

Highlight the Dates if its over a year

August 28, 2018

This post will guide you how to highlight the dates that are over 1 year in excel. How do I highlight the dates over a year old using conditional formatting feature in excel. How to use conditional formatting to highlight if the dates are over a year in excel. How to highlight cells color when… read more »

Comparing Columns Using Conditional Formatting Icon Sets

August 13, 2018

This post will guide you how to compare the adjacent cells in the different columns using Conditional Formatting Icon Sets in Excel. How do I compare cells in the adjacent rows using Conditional Formatting Icon Sets in Excel. How to compare Columns or rows using Conditional Formatting Icon Sets to show increase or decrease status… read more »

Find Duplicate Values in Two Columns

January 5, 2019

This tutorial will show you how to find duplicate values in two given columns in Excel. Or How to compare two columns and find duplicate entries in Microsoft Excel worksheet. And you will learn two methods to compare columns so that the duplicate values can be highlighted or listed in a range of Cells. Assuming… read more »

Change background color of cells based on value

January 26, 2018

This tutorial will guide how to change the background color of cells based on specific value in excel. How to change the background color automatically when the cell value’s changes. You will learn that how to change the background color based on the certain value of cells with conditional formatting command in excel 2016, 2013… read more »