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.

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.

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.

(ig) wrote in message . com...
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.

You can do it in the Excel interface using a conditional format that
uses a formula, rather than a cell value, as its condition:

1. Choose Format | Conditional Formatting
2. Click the first down arrow and choose Formula Is.
3. In the box to the right of Formula Is, type =COUNTIF(A1:A1000,
"x")0
4. Click the Format button, click the Color down arrow, and choose
Red.
5. Click OK twice.

Curt
--

Curt Frye
Professional Writer and Speaker
Author of Microsoft Excel Version 2003 Step by Step, lead author of
Microsoft Excel 2003 Programming Inside Out, from Microsoft Press

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.

Hi Frank

thanks ... just couldn't figure it

Cheers
JulieD

"Frank Kabel" wrote in message
...
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.

The question was asked a little differently somewhere else.
Had a few more names and who was to be red and or not.

"JulieD" wrote in message news:%
thanks ... just couldn't figure it

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