Conditional Format issue

[Patrick C. Simonds]

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

 

[Guest]

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.

 

[Guest]

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]

Thank you, but this does not display Conditional Format formulas

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




---
avast! Antivirus: Inbound message clean.
Virus Database (VPS): 000763-0, 08/01/2007
Tested on: 8/1/2007 7:33:27 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:41:45 AM
avast! - copyright (c) 1988-2007 ALWIL Software.
http://www.avast.com

 

[Patrick C. Simonds]

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

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"







---
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

 

[Gord Dibben]

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