Hi,

Do the following:

1. On the Tools menu, click Options. The Options dialog box is displayed.
2. Click the View Tab.
3. Under Windows Options, select the Formula check box. All the formulas are
displayed in the worksheet.
4. Click OK to return to the Worksheet.
5. On the Edit menu, click Replace. The Find & Replace dialog box is
displayed.
6. In the Find what text box, enter the value you want to search.
7. In the Replace With text box, enter the value you want to replace.
8. Click the Replace All button to replace all the occurance of the value in
the find text box.

Challa Prabhu

"Patrick C. Simonds" wrote:

I have hundreds of cell spread throughout my worksheet which have condition
formats which contain "PTO" which I need to change to "FRD". I can not
just blow away the conditional formatting for these cells and start over
because these cells contain other conditional formatting. Is there any
(easy) way to make this change to all cells that contain the conditional
formatting in question?




---
avast! Antivirus: Outbound message clean.
Virus Database (VPS): 000762-5, 07/31/2007
Tested on: 7/31/2007 7:04:05 PM
avast! - copyright (c) 1988-2007 ALWIL Software.
http://www.avast.com