So U actually want select a range to look in then select a range of what to look for and then if found change the interior colour of the cell. Is that correct? Dave