Conditional Formatting

[Joanne]

Hi

I have used conditional formatting to highlight a particular cell but is it possible to format a spreadsheet so that if a particular word (in this case "withdrawn") is entered into a cell, the whole row is highlighted, not just that cell?

Many thanks,
Jo

[Pecoflyer]

I would not advise using CF on an entire sheets, as it will slow your sheet down tremendously
Does your word always appear in the same column ( different rows)?

If so, select a number of rows starting in row1 ( again, not too many and not necessarily all columns) at once then use the following assuming your words appear in col C
=ISNUMBER(SEARCH("withdrawn",$C1))
and format as required


If in different columns
try

=SUMPRODUCT(--NOT(ISERROR(SEARCH("withdrawn",$A1:$Z1))))>0
as CF
(there should be something more elegant)

[Joanne]

Hi Pecoflyer

Apologies for the delay. This worked perfectly for me.

Many thanks,
Joanne

[Pecoflyer]

You're welcome.
Please mark thread as solved ( see my sig)

[Joanne]

Hi

Apologies if it is obvious, but I can't see how to mark a problem as solved.

[Pecoflyer]

It is explained in my signature

[Joanne]

Still not getting it. When I click on "Thread Tools", I just get "Printable Version" option.

[Joanne]

Apologies, please ignore the last message!

[Pecoflyer]

No worries