Want to to alternate row colors in Excel? You can apply color in alternate row & column in Excel spreadsheet using Conditional Formatting.

Functions are the driving force of any Microsoft Excel spreadsheet, generating a single value or an array of results based on certain arguments you input. However, combining—or nesting—functions ...

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.

Fortunately, Excel enables users to instantly fill an entire row or selection of cells with the same formula with just a few keystrokes, with or without formatting.

A. Microsoft Excel is best known for crunching numbers, but it’s also a powerful tool for organizing tasks. Checkboxes can ...

Excel allows defined functions to be executed in Worksheets by a user. Instead of a formula based on the color of a cell, it is better to write a function that can detect the color of the cell and ...

Learn how to highlight dates before today and a specific date with and without using the Today() function in Microsoft Excel.

Think you’ve mastered Microsoft Office? Think again. Tucked away in every Office program are time-saving tricks and powerful ...