Alternating row or column colors assists data identification by making the row or column easier to distinguish. In Microsoft Excel, you can achieve this effect using conditional formatting to change ...

Grid controls are great for displaying large quantities of data, and highlighting can make the data more readable. Learn how to programmatically control this highlighting without add-on controls. Grid ...

Discover advanced Excel conditional formatting techniques. Automate your spreadsheets by detecting duplicates, finding ...

Please note: This item is from our archives and was published in 2005. It is provided for historical reference. The content may be out of date and links may no longer function. Q. I know I can use ...

How do you set up a worksheet with alternating colored rows like the traditional columnar pad design? There are many ways, but the easiest, for both Excel 2003 and 2007 is with a Conditional ...

Whether you’re using Microsoft Excel 2008 ( ; $400 as part of Office 2008) or 2004, you need some tricks up your sleeve for easing day-to-day tasks, such as entering data or custom sorting, as well as ...

A giant grid of numbers can be mind-numbing. Once I discovered the magic of color-coded rules, spotting shifts and irregularities got a whole lot easier. A vivid spreadsheet quickly calls attention ...

Do you want your Microsoft Access Datasheet table to look more appealing with your cells shade with colors and gridlines styles? There are features in Microsoft Access that will allow you to get the ...