Hi Chris

Scroll over your selected area - select EDIT and REPLACE.

It prompts you to find what and replace with.


"Chris" wrote in message
...
How do I search for a certain number in cells and either highlight the row
or
replace the cell with another number?