How to Highlight Cells with Duplicate Values in a Range? By using Conditional Formatting in Excel we can Highlight Duplicate Cells. Steps to do: ======== Select the Cells/Range you wish to compare Select the Home Tab Select Conditional Formatting Select Highlight Cell Rules Select Duplicate Values Select a Highlight Color Select Okay Tada..!! Magic… All the […]
Articles Tagged: Cell Formatting
How to calculate the Age between two Dates / Times and show it in a meaningful way?
Qsn: How to calculate the Age between two Dates / Times and show it in a meaningful way?
Sol: Use the simple formula “A-B” (NewDate – OldDate) just same as we subtract two numerical values, but added with a simple trick… Know how…
Filter/Identify Unique Values or Remove Duplicate Values
Filter/Identify Unique Values or Remove Duplicate Values In Microsoft Office Excel 2007, you have several ways to Filter for Unique Values or Remove Duplicate Values, 3 most commonly used options are listed below: 1 > To highlight unique or duplicate values, use the Conditional Formatting command in the Style group on the Home tab. 2 […]
Round Numbers To The Nearest 1000
Round Numbers To The Nearest 1000 Often in Excel, when working with large numbers it is common practice to show numbers as thousands, with a note to that effect shown somewhere on the report. To display your numbers to the nearest thousand in Excel you do not need to change any numbers or do any […]