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

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)

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Hi Pecoflyer

Apologies for the delay. This worked perfectly for me.

Many thanks,
Joanne

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

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Hi

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

It is explained in my signature

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

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

Apologies, please ignore the last message!

No worries

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post