One of the better additions to Excel 2007 are, in my view, the functionality added to tables http://www.jkp-ads.com/articles/Excel2007tables.asp. I was recently working on a 2007 project and I was looking to add some highlighting using conditional formatting. That will be easy thought I, but as usual, I was way off the mark. Formatting The Table For the sake of clarity, I will not use the actual formatting that I was trying, but a far simpler case. Figure 1 shows an example of a typical table in Excel 2007. Figure 1 Let’s assume that I want to show those rows where … Continue reading Who Scratched My Table?