I want to do something very simple but can't seem to automate it...

I want to search a spreadsheet for a specific word, i.e. "Smith", and then
highlight the entire row that that specific word appears in.

Try conditional formatting

"Ernesto" wrote:

I want to do something very simple but can't seem to automate it...

I want to search a spreadsheet for a specific word, i.e. "Smith", and then
highlight the entire row that that specific word appears in.

Thanks, but in so far as I am aware, conditional formatting applies only to
cells, not to rows/columns. Is there a way to expand this to rows?

"Teaky" wrote:

Try conditional formatting

"Ernesto" wrote:

I want to do something very simple but can't seem to automate it...

I want to search a spreadsheet for a specific word, i.e. "Smith", and then
highlight the entire row that that specific word appears in.

Thanks, but conditional formatting applies only to cells. Is there a way to
expand this to rows/columns?

"Teaky" wrote:

Try conditional formatting

"Ernesto" wrote:

I want to do something very simple but can't seem to automate it...

I want to search a spreadsheet for a specific word, i.e. "Smith", and then
highlight the entire row that that specific word appears in.

Select the whole row and apply CF. If using a formula to refer to a cell,
make the column absolute.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Ernesto" wrote in message
...
Thanks, but conditional formatting applies only to cells. Is there a way
to
expand this to rows/columns?

"Teaky" wrote:

Try conditional formatting

"Ernesto" wrote:

I want to do something very simple but can't seem to automate it...

I want to search a spreadsheet for a specific word, i.e. "Smith", and
then
highlight the entire row that that specific word appears in.

Thanks for all the help, but that won't work either.
I have a spreadsheet that looks like

7-3 3-11 11-7
Monday Smith Nelli Maria
Tuesday George Frank Horner
Wednes Maria Ellen Louis
Thursda George Nelli Cathy
Friday Ellen Smith Frank

but much much bigger...

I want to automatically highlight all the ROWS that have the name "Smith"

How best to do this?

should be easy.... but I can't figure it out!


"Bob Phillips" wrote:

Select the whole row and apply CF. If using a formula to refer to a cell,
make the column absolute.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Ernesto" wrote in message
...
Thanks, but conditional formatting applies only to cells. Is there a way
to
expand this to rows/columns?

"Teaky" wrote:

Try conditional formatting

"Ernesto" wrote:

I want to do something very simple but can't seem to automate it...

I want to search a spreadsheet for a specific word, i.e. "Smith", and
then
highlight the entire row that that specific word appears in.

CF with a formula of

=ISNUMBER(MATCH("Smith",1:1,0))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Ernesto" wrote in message
...
Thanks for all the help, but that won't work either.
I have a spreadsheet that looks like

7-3 3-11 11-7
Monday Smith Nelli Maria
Tuesday George Frank Horner
Wednes Maria Ellen Louis
Thursda George Nelli Cathy
Friday Ellen Smith Frank

but much much bigger...

I want to automatically highlight all the ROWS that have the name "Smith"

How best to do this?

should be easy.... but I can't figure it out!


"Bob Phillips" wrote:

Select the whole row and apply CF. If using a formula to refer to a
cell,
make the column absolute.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Ernesto" wrote in message
...
Thanks, but conditional formatting applies only to cells. Is there a
way
to
expand this to rows/columns?

"Teaky" wrote:

Try conditional formatting

"Ernesto" wrote:

I want to do something very simple but can't seem to automate
it...

I want to search a spreadsheet for a specific word, i.e. "Smith",
and
then
highlight the entire row that that specific word appears in.