Excel conditional formatting is all about visualizing data with colors. You may use contrasting colors to represent data categories or gradients to "map" data with some intrinsic order. When a certain pallet is used to visually represent data, it becomes a color scale. Continue reading
To compare different categories of data in your worksheet, you can make a chart. To visually compare numbers in your cells, colored bars inside cells are a lot more useful. Excel can show bars along with cell values or display only the bars and hide the numbers. Continue reading
As simple as it may sound, highlighting blank cells with conditional formatting is quite a tricky thing. Basically, it's because a human understanding of empty cells does not always correspond to that of Excel. Continue reading
Microsoft Excel has a number of inbuilt features to create graphs. Regrettably, a heat map is not on board. Luckily, there is a quick and simple way to create a heat map in Excel with conditional formatting. Continue reading
When viewing a large worksheet for a long time, you may eventually lose track of where your cursor is and which data you are looking at. To know exactly where you are at any moment, get Excel to automatically highlight the active row and column for you! Continue reading
In case you want to bring focus to the highest or lowest N values in a dataset, the best way is to highlight them in different colors. This article will teach you how to do this with Excel's presets and create your own conditional formatting rule based on formula. Continue reading
In a small dataset, you can easily spot all the blanks with your own eyes. But in a huge file containing hundreds of rows, pinpointing empty cells manually is next to impossible. This tutorial will teach you four quick and easy ways to highlight blank cells in Excel so that you can visually recognize them. Continue reading
Are you looking to calculate the expiration date that is exactly 90 days from now? Or you need to know the date that occurred 60 days before today? Whatever your task is, this tutorial will teach you how to make your own date calculator in Excel in under 5 minutes. Continue reading
In our previous tutorial, we were looking at Excel If contains formulas that return some value to another column if the target cell contains a specific value. Aside from that, what else can you do if a cell contains certain text or number? Continue reading
Learn how to quickly highlight entire rows based on another cell value in Excel. Continue reading
If you want to quickly find, filter and highlight unique or distinct values in your Excel worksheets, this tutorial will show you fast and efficient ways. Continue reading
Today, we are going to have a close look at how to show duplicates in Excel. You will learn how to shade duplicate cells, entire rows, or consecutive dupes using conditional formatting. Also, you will see how to highlight duplicates with different colors using a specialized tool. Continue reading
The tutorial explains how to search for duplicates in Excel. You will learn a few formulas to identify duplicate values or find duplicate rows with or without first occurrences. You will also learn how to count instances of each duplicate record individually and find the total number of dupes in a column, how to filter duplicates, and more. Continue reading
Learn a variety of methods to compare Excel files and identify differences between them. See how to open two Excel windows side by side, how to use Excel formulas to create a difference report, highlight differences with conditional formatting, and more. Continue reading
The tutorial demonstrates a number of techniques to compare and match two or more columns in Excel with formulas, conditional formatting and the specialized wizard. Continue reading
Many tasks you perform in Excel involve comparing data in different cells. For this, Microsoft Excel provides six logical operators, which are also called comparison operators. This tutorial aims to help you understand the insight of Excel logical operators and write the most efficient formulas for your data analysis. Continue reading
Invest a few minutes and learn how to correctly use relative and absolute cell references in Excel conditional formatting rules. This knowledge will certainly save you far more time in the long run. Continue reading
See how to apply Excel conditional formatting to dates. Learn how to use formulas to highlight weekends and holidays, format cells when a value is changed to a date, shade upcoming dates and delays, conditionally format dates based on the current date, and more. Continue reading
This tutorial explains how to use Excel formulas to format cells and entire rows based on the values you specify or based on another cell's value, and provides a handful of formula examples. Continue reading
Assuming you already know the basics of Excel conditional formatting, let's move on and see what options you have with regard to icon sets and how you can leverage them in your projects. Continue reading
Excel conditional formatting is a really powerful feature when it comes to applying different formats to data that meets certain conditions. It can help you highlight the most important information in your spreadsheets and spot variances of cell values with a quick glance. Continue reading
See how you can quickly alternate row and colomns colors in your worksheets by using Excel Table Styles. You will also learn a few smart formulas to highlight banded rows and columns with 3 different colors and to shade groups of rows based on a value change. Continue reading
Learn how to quickly change the color of the entire row based on a single cell's value in your Excel worksheets. Tips and formula examples for number and text values. Continue reading
In this article, you will find two quick ways to change the background color of cells based on value in Excel 2016, 2013, and 2010. Also, you will learn how to use Excel formulas to change the color of blank cells or cells with formula errors. Continue reading
