How to highlight calculated fields in an Excel spreadsheet?

Question

Is there a simple way to do this, via macro or otherwise? By calculated field I mean a field that is computed from other fields, versus raw entered values. By highlight I mean colored differently. I need this to better understand a large spreadsheet from a client.

Answer 1

TLDR;

Use Conditional Formatting with a Formula to highlight all cells that contain a formula.

Details

In MS Office 365 Version: 5.0.4667.1002, the following works

1. Select a range of cells.
   • Case1: Use Ctrl + A to select all cells.
   • Case2: Select a specific range.
2. Go to the Home tab, Styles section, and choose Conditional Formatting > New Rule.
3. The "New Formatting Rule" dialog will open.
4. Choose "Use a formula to determine which cells to format"
5. In the textbox, add the following rule: =IsFormula(A1)
   • Case1: If you selected all cells, use A1 because it is the first cell.
   • Case2: If you selected a specific range, replace A1 with the first cell in your range.
6. Click Format...
7. The "Format Cells" dialog will open.
8. Choose the format you would like to apply. E.g. a yellow background.
9. Click OK.
10. All cells that have formulas will now have, for instance, a yellow background.

Screenshot