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 | 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...