by admin | Sep 25, 2012 | Excel | General
In Part One of this blog posting, we’ve already looked at using Conditional Formatting to identify duplicates (and unique values). In the second scenario, I’m going to look at where we have a list of rooms/dates/times and we want to see if there are any...
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...