You can highlight all of the formulas in a spreadsheet by following the following steps:
Step 1: Select the range, Click Edit > Go To > Special > Select Formulas, click OK
Step 2: Click the fill color of your choice
Illustrated:
- Highlight the range
- Select Edit > Go To
- Select Special
- Select Formulas, click OK
- Click the fill color of your choice
If you liked my post, feel free to subscribe to my rss feeds
BlogoSquare