Hi
in this case i would try the following:
- select cell B2
- goto 'Conditional Format' and enter the formula
=COUNTIF($A$1:$A$1000,"x")

--
Regards
Frank Kabel
Frankfurt, Germany


JulieD wrote:
Hi Frank

i couldn't figure out how to do it in Conditional Formatting as my
understanding of the OPs question was if any cell in A1:A1000 has "x"
in it then Pete (say in B2) goes red ... if he only wanted Pete to go
red if A1 was red then it would be a different matter


any ideas

Cheers
JulieD

"Frank Kabel" wrote in message
...
Hi
have a look at 'Format - Conditional Format' for this

--
Regards
Frank Kabel
Frankfurt, Germany


ig wrote:
greetings i want to know how to change the color of a cell if the
letter x esists in a range of cells........... ie


a b c d
pete x

so the word pete would be black if nothing was in a1:a1000 or in
this case it would need to be in red.