or you can use same fomula on one cell and then use copy-paste
special-formats

sasa

"Dave Peterson" wrote in message
...
Select your table (I used A1:X99)
and with A1 the active cell
format|conditional formatting
formula is: =countif(a1,"*carla*")0



SBárbara wrote:

Hi, Tom

Perhaps I wasn't explicit...I want to write a key word ... for example in
table appears "Loja da Carla"; "Casa da Carla"...and I want to use
"Carla" as
key word and automatically all cells that contains "Carla" turn to red
(or
another color).
Is it possible to make this in Excel?

Regards,
SBárbara

"Tom" escreveu:

The following will set your certain value to red each time it appears:
FORMAT CONDITIONAL FORMATTING
CELL VALUE IS EQUAL TO 'type in your value you're looking for
FORMAT 'select the color you want it to turn to
OK

Regards,
Tom

"SBárbara" wrote:

I have a list of values (validationlist), and i want to select one,
and
automatically in a table where the chosen value appears some times,
this
value turns to red.

--

Dave Peterson