Open the Excel spreadsheet containing the columns you want to compare. Select the data in both columns, excluding the heading. In the Styles section in the Home tab, click on Conditional Formatting.

Personalize your emails: Add a signature in Outlook with the click of a button Block emails: How to report spam and unsubscribe on Gmail How to freeze a column in Excel Follow these steps to ...

Adding a partial column Sometimes, you want to add a new column to just part of a spreadsheet. That's easy to do as well. Step 1: Select the cells to the right of where you want to add the new column.

Launch Excel or open an existing table with numbers to add. Type the calculation into the cell you want to place the result, for eg =15+25+4+10+5, Press the Enter key to see the result. 2] How to ...

2] Find differences by comparing two columns Another purpose for the VLOOKUP function is to find differences within two columns. This is an easy task, so let us talk about how to get this done. We ...

Using Built-In Excel Functions Another way to split data into multiple columns is to use some of Microsoft Excel's functions. If you choose this route, remember that the split values will be ...

Inserting a lot of columns or rows in Microsoft Excel is awkward and prone to mistakes. When you need to enter dozens or more columns, use this VBA procedure for ease and accuracy.

Running totals show how figures build over an extended period, one entry at a time, allowing you to see trends and patterns ...

Add or remove a check mark next to "View" to reveal or hide, respectively, the Excel headings on the spreadsheet. The headings for the columns and rows are linked, so you can only either see them ...

Microsoft Excel 2010 can convert a worksheet to a data table to help you quickly analyze your related data in formatted rows and columns. When you need to expand the table layout, apply the Home ...