Tag Archive: conditional formatting

Excel Tutorial – Highlighting Duplicate Values

Excel 2007 Tutorial – Highlighting Duplicate Values If you’ve worked with Excel 2007 for a little while, you’ve probably noticed how much easier it is to delete duplicates. What if you wanted to take a look at the duplicate values before you deleted them? This is also very easy. Simply highlight the range of cells …

Continue reading »

Excel Tip – Conditional Formatting.

Excel Tip – Conditional Formatting This tip comes in handy when you are using Excel for a report. You can set it up so that when values are above or beneath a particular threshold, the data will be formatted in a particular manner. Here is an example of a way you can use conditional formatting: …

Continue reading »