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

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.

Functions are the driving force of any Microsoft Excel spreadsheet, generating a single value or an array of results based on ...

How to Make Excel Continue to Count Up for Each Row. Entering a series of sequential numbers into an Excel spreadsheet, one per row, can be a time-consuming and repetitive task.

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 ...

Office expert Susan Harkins teaches you two ways to highlight the lowest and highest values in an Excel row or column.

How to Plot a Formula in Excel. Unless you are an accountant or a math whiz, the formulas used in financial calculations may seem like random, nonsensical strings of numbers, letters and Greek ...