"StargateFan" wrote in message
...
I'm hoping that something like this can be done: if any email address
in a worksheet has a certain text string in it, in this case
", what would the conditional formatting code be that will
then colour that row yellow, if this is indeed possible? The rows go
from 2 to 15, if that info is needed, i.e., A2 to A15, B2 to B15, etc.
(or if necessary, if it's easier to just code the entire row, that
would be acceptable, too, rather than the area of row that is visible
in the sheet).


is there an email in only one column per row? if so then you just have to
select the cells in row 1, go to conditional formating . change the
condition to Formula=, and enter (assuming the email appears in column A)

",$A1)

and set the formating to yellow background

then select the cells, copy. select all the cells below that row and paste
special 'formats'

If the emails appear more than once per row then it's a little more
complicated, so post back in that case.

Iain King