Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Format issue
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Format issue
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Format issue
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Format issue
Thank you, but this does not display Conditional Format formulas
"challa prabhu" wrote in message ... 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 --- 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Format issue
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Format issue
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Format Formula Issue | Excel Worksheet Functions | |||
Conditional Format Issue | Excel Worksheet Functions | |||
conditional formatting issue | Excel Worksheet Functions | |||
Conditional Format Issue | Excel Worksheet Functions | |||
Conditional Formating issue..... | Excel Worksheet Functions |