| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract number from cell when specific format is found | Excel Worksheet Functions | |||
| search folder/directory for a phrase inside excel files | Excel Discussion (Misc queries) | |||
| Found Cell Highlighting after Search | Excel Discussion (Misc queries) | |||
| Conditional format if cell match found in another range of cells | Excel Worksheet Functions | |||
| when I search for data in Excel, the found cell cannot be seen | Excel Discussion (Misc queries) | |||
Threaded Mode
