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. How do I create a ...

Microsoft Excel’s conditional formatting is a wonderful “automatic” feature that allows you to formats cells based on the value of those cells or the value of the formulas in those cells. For example, ...

For you advanced users who want to skip ahead: You apply the conditional formatting using a custom formula and some variation on the INDIRECT function. In addition to specifying the column and row, ...

Whether you’re tracking sales, managing budgets, or analyzing trends, the challenge of pulling out meaningful insights from an Excel spreadsheet can feel like searching for a needle in a haystack. But ...

How to use Excel’s conditional formatting to compare lists Your email has been sent Whether you're comparing a single list or several, Excel's conditional formatting can get the job done. Comparing ...

Understanding Excel’s conditional formatting rules can help prevent unintended results Your email has been sent Avoid frustration and unintended formatting by learning how Excel applies conditional ...