This tutorial shows how to create 1st and 2nd level outline formatting using excel formulas.… Read More
Clean and reformat telephone numbers using SUBSTITUTE function in Excel
One way to clean up and reformat telephone numbers is to strip out all extraneous … Read More
Shade alternating groups of n rows in Excel
This tutorial shows how to Shade alternating groups of n rows in Excel using the … Read More
Highlight rows that contain in Excel
This tutorial shows how to Highlight rows that contain in Excel using the example below;… Read More
Highlight row and column intersection exact match in Excel
This tutorial shows how to Highlight row and column intersection exact match in Excel using … Read More
Highlight numbers that include symbols in Excel
This tutorial shows how to Highlight numbers that include symbols in Excel using the example … Read More
Highlight rows with blank cells in Excel
This tutorial shows how to Highlight rows with blank cells in Excel using the example … Read More
Highlight values not between X and Y in Excel
This tutorial shows how to Highlight values not between X and Y in Excel using … Read More
Highlight values greater than in Excel
This tutorial shows how to Highlight values greater than in Excel using the example below;… Read More
Highlight values between in Excel
This tutorial shows how to Highlight values between in Excel using the example below;
Formula
… Read MoreHighlight top values in Excel
This tutorial shows how to Highlight top values in Excel using the example below;
Formula
… Read MoreHighlight unprotected cells in Excel
This tutorial shows how to Highlight unprotected cells in Excel using the example below;
Formula
… Read MoreHighlight unique values in Excel
This tutorial shows how to Highlight unique values in Excel using the example below;
Formula
… Read MoreHighlight rows with dates between In Excel
This tutorial shows how to Highlight rows with dates between In Excel using the example … Read More
Excel Data validation allow text only
This tutorial shows how to create Data validation to allow text only in Excel using … Read More
Excel Data validation allow numbers only
This tutorial shows how to create Data validation to allow numbers only in Excel using … Read More
Highlight dates in same month and year in Excel
This tutorial shows how to Highlight dates in same month and year in Excel using … Read More
Highlight dates in the next N days in Excel
This tutorial shows how to Highlight dates in the next N days in Excel using … Read More
Highlight dates that are weekends in Excel
This tutorial shows how to Highlight dates that are weekends in Excel using the example … Read More
Highlight duplicate columns in Excel
This tutorial shows how to Highlight duplicate columns in Excel using the example below;
Formula
Highlight duplicate rows in Excel
This tutorial shows how to Highlight duplicate rows in Excel using the example below;