View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sunday88310 Sunday88310 is offline
external usenet poster
 
Posts: 103
Default 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