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