| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to change cell value if cell contain specified word
Dear All,
I am looking for a formula that will change all the cells value if that contains the specified word. e.g. GPS Ignition off Unlock Ignition off Health check Ignition off GPS Unlock Ignition off if a cell contains Ignition off then cell value should change with Ignition off and remove the other status with Ignition off. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change the cell value if there is any word exist in that ce | Excel Discussion (Misc queries) | |||
| Trying to change the background of a cell if I type a certain word | New Users to Excel | |||
| Trying to change the background of a cell if I type a certain word | Excel Discussion (Misc queries) | |||
| I only want to change the formatting of one word in an Excel cell | Excel Discussion (Misc queries) | |||
| If a cell is a certain word I would like it to change colors. | Excel Discussion (Misc queries) | |||
Threaded Mode
