Find/Replace w/ Conditional Formatting?

[bludovico]

Is there a way to do a "find / replace" for a conditonal format? I need to replace "F"s with "P"s for example.

[swatsp0p]

There is an option in Find/Replace to 'Match Case', so it will only look for the case you enter in the Find criteria.

NOTE: if you choose "replace all", any matches in a formula will be replaced as well. e.g. =IF(....) will become =IP(....) [not good].

HTH

Bruce