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

Learn how to create a drop-down list in Excel without or with color using conditional formatting and data validation rules.

Save this for the spreadsheet jocks in your office—we'd bet even the experts don't know all of these formula tips.

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

Want to know how to show formulas in Excel? We’ve got you covered. When using formulas in an Excel spreadsheet, you may want them visible instead of the cell results, or you may want to see them in ...

The default active cell format in Microsoft Excel isn't all that easy to see, but you can use this easy-to-implement code solution to change that.

Q. Is there a way to conditionally format Excel so that my formulas automatically display a different font color? In this example, we have now successfully applied conditional formatting to cell A1, ...

Learn about the weighted average cost of capital (WACC) formula in Excel and use it to estimate the average cost of raising funds through debt and equity.