Identify Excel Cells Containing Formulas
Q. Is there a way to command Excel to highlight all the cells in a worksheet that contains formulas?
A. Sure. Just click on Edit , Go To and then Special , which is at the bottom of the screen.
That opens the Go To Special screen (see screenshot below). Click on Formulas .
When you click on OK , the cells that contain formulas will be highlighted in dark blue and look like this:
