Mass Forumla Change

[Ghalmaraz]

Hi,

I have a large number of formulas that link from one work sheet to the other
which also use IF functions. Is there a quick way to change the IF criteria
(say from "1" to "2") for all the formulas at once?

Cheers

G

 

[Bernie Deitrick]

G,

Select the cells, press Ctrl-h, then type in the find something that is completely unique about the
formula. For example:

=IF(A1=1,This,That)

You would want to replace =1 and not just 1 so that you don't change the cell references as
well, and then for the replace with, use =2

And click Options, and choose the lookin Formulas option.

HTH,
Bernie
MS Excel MVP