News

Microsoft Excel 2007's conditional formatting feature allows you to format cells based on certain criteria. As an example, you might want the row color to change based upon a credit or debit on a ...
How to Alternate White and Gray Cells in Excel. Alternating row or column colors assists data identification by making the row or column easier to distinguish. In Microsoft Excel, you can achieve ...
To change Gridline color in Excel, use Excel Options, apply a custom-colored border to the cells, or apply a custom line color. Full details here.
A row-by-row formatting rule is as easy to apply as a column-by-column in Microsoft Excel, but you might not get the results you thought you would.
Counting records or values in Microsoft Excel is easy. Counting individual cells by their fill color definitely isn't. Using an old function and a matrix tames the problem.