by admin | Sep 25, 2012 | Excel | Conditional Formatting, Excel | General, Excel | Useful tricks
In this post, I’m going to show you how to locate duplicates in Excel. I’m going to look at two scenarios. In the first scenario – we just have to identify duplicate/unique values in a list. For this I’m going to use Conditional Formatting . I...
by admin | Aug 20, 2012 | Excel | Conditional Formatting, Excel | Intermediate Lessons
In a previous post, I showed you how to use conditional formatting in Excel to highlight entire rows based on a specified criteria. In this post, I am going to show you how to use the AND function to conditionally format rows based on multiple criteria. Please enable...
by admin | Aug 20, 2012 | Excel | Conditional Formatting
In this video, I am going to show you how to use conditional formatting to highlight an entire row based on a single criteria (rather than just highlighting the single cell). In another post, I am going to show you how to use the And function with conditional...
by admin | Jun 5, 2012 | Excel | Advanced Lessons, Excel | Conditional Formatting
Conditional formatting Conditional formatting in Excel 2007 (and later) allows us to colour cells on a spreadsheet depending on whether or not they meet certain conditions. While it existed to some degree in Excel 2003, it has been seriously beefed up in Excel 2007...