different color if an x esists in range

I

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.
 
J

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
 
C

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.
Click to expand...

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 [email protected]
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
 
F

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

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.
 
Top