different color if an x esists in range
 

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.

different color if an x esists in range
 

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.

different color if an x esists in range
 

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.

different color if an x esists in range
 

different color if an x esists in range
 

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.

different color if an x esists in range
 

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.

different color if an x esists in range
 

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