Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Feb 2001
    Leigh on Sea, Essex, England
    Thanked 0 Times in 0 Posts

    Find/Replace differences 2003-2007 (2003/2007)


    I have a spreadsheet which lists data sets on a weekly basis and uses colour (formatted by VBA code) to highlight those that were deleted from the previous load of a given data set. IN 2003, after reviewing the deleted data, I can do a global "find & replace" with the "deleted" format in the find box and no format set in the replace box. This very handily deletes all of the text in the deleted cells - a second find and replace with normal format set then reverts the format to the "normal".

    In 2007, though, this process doesn't seem to work. My working assumption is that the find & replace dialog picks up other parts of the formatting that I don't care about, such as borders or fonts, and will only find some (or none) of the affected cells. The other curiosity is that if I choose one of the cells using "choose format from cell", then even with white text, the font still shows as "automatic" - which is normally black, or has been since the year dot.

    Before I go completely mad, please help!



    PS - tried using styles, which is good but I would need to be able to search for them to delete the text, and searching for a style doesn't seem to be an option!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Find/Replace differences 2003-2007 (2003/2007)

    I don't have Excel 2007, so I can't test, but have you clicked Clear in the Find Formatting dialog before specifying the color you want to search for?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts