How to compare two columns in Excel

How to compare two columns in Excel

Comparing the data in two different columns is a frequently used method in data analysis. In Excel, you can compare using formulas or highlighting. In this guide, we’re going to show you how to compare two columns in Excel using these two methods. Compare two columns...
How to highlight empty cells

How to highlight empty cells

It’s often a good idea to highlight empty cells in a data set to help easily identify the outliers. Here, you can find out how to highlight empty cells dynamically using Conditional Formatting. Steps Begin by selecting the data range B3:H10 Open the Conditional...
How to highlight cells by values

How to highlight cells by values

Highlighting cells is a good way to visualize content to locate areas that needs attention. Excel’s Conditional Formatting feature is a great tool for this job. How to highlight cells by values article will show how you can create highlight cells based on...