different color if an x esists in range

[ig]

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.

 

[Frank Kabel]

Hi
have a look at 'Format - Conditional Format' for this

 

[JulieD]

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

 

[Curt Frye]

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 (e-mail address removed)
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

 

[Frank Kabel]

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")

 

[JulieD]

Hi Frank

thanks ... just couldn't figure it

Cheers
JulieD

 

[David McRitchie]

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