You can select all the cells and change the one condition from "pto" to "frd"
without affecting the other conditions.

Assuming you have multiple conditions as in condition1, 2 and 3


Gord Dibben MS Excel MVP

On Wed, 1 Aug 2007 07:44:49 -0700, "Patrick C. Simonds"
wrote:

Thank you, but it appears you can not use Find and Replace to search within
Conditional Formats.


"Sunday88310" wrote in message
...
the information you have provided, leads me to believe you can just use
find
and replace, if you need more information on find and replace type find
and
replace in your Excel help files.
--
William<"M"




"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






---
avast! Antivirus: Inbound message clean.
Virus Database (VPS): 000763-0, 08/01/2007
Tested on: 8/1/2007 7:33:19 AM
avast! - copyright (c) 1988-2007 ALWIL Software.
http://www.avast.com







---
avast! Antivirus: Outbound message clean.
Virus Database (VPS): 000763-0, 08/01/2007
Tested on: 8/1/2007 7:44:50 AM
avast! - copyright (c) 1988-2007 ALWIL Software.
http://www.avast.com