Results 1 to 11 of 11

only show/highlight rows where a certain word appears in any column

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-29-2011
    Location
    Scotland
    MS-Off Ver
    Excel 2003
    Posts
    122

    only show/highlight rows where a certain word appears in any column

    hi, ive been trying to autofilter, conditional format etc a spreadsheet so that it only shows/highlights rows where the words 'film' and/or 'development' and/or 'production' appears in any of the columns (A to I).

    i cant get it to work after hours of playing around, any ideas?

    I guess an alternative method would be to delete all rows where any of the specified words 'do not' appear...any help much appreciated.
    Last edited by intothewild; 03-28-2012 at 03:23 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1