Microsoft Excel: Change the Formatting of Cells Containing Formulas
When working with a large spreadsheet, it’s often useful to know which cells are formulas as opposed to values. It’s easy to apply such formatting after you’ve set up your worksheet.
- From the Edit menu, select Go To… and then click the Special button.
- Select the Formulas option button and click OK. Excel will highlight every formula in the active sheet.
- Using the Formatting toolbar (or to go the Format Cells dialog box) and format the cells as you desire.
Assuming you’ve otherwise used Excel’s default colors, your worksheet will now show static values using black text and formula results with the formatting you previously selected.
If you have any questions regarding this tip or need help implementing it in your own projects, contact Ranelle Maltas, Application Support Associate, at 472-0585 or e-mail at rmaltas2@unl.edu.