#Excel Short & Sweet Tip (Find Formulas)#2

With the active cell at A1, create a defined name formula in Name Manager called IsFormula using this Excel formula:

=LEFT(FORMULATEXT(A1),1)=”=”

Then, apply a conditional format to A1 as shown below:

xlss002_f1

Then, you can Copy/Paste Special/Formats to the region containing formulas.

Advertisements

One thought on “#Excel Short & Sweet Tip (Find Formulas)#2

  1. Pingback: #Excel Super Links #150 – Special Edition | Excel For You

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s