View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] Leaper@FakeEail.cooo is offline
external usenet poster
 
Posts: 3
Default Search a Range for a phrase and Format cell if found

Hi
I've got a spread sheet containing spec's for vehicles, I want to search
them to highlight specific items by changing the cell color

Here's an example of the sheet, this is one column with each line in a cell.

(BYRAB) PROGRAMMABLE DRIVER SEAT
(CBLAE) 315 MHZ DOOR LOCK FREQUENCY
(CFKAA) LESS HEADLAMP CLEANING
(CBSAC) SINGLE LOCKING PWR LOCK LATCH
(DAQAA) LESS BLOCK HEATER RECEPTACLE

I need to highlight any that have "LESS" ,there are 77 columns vehicle of
data by 100 rows

would be gratefully for any help

Kev