change color of cell if an X exists in range

how do i change the color of a cell (red or black) depending on if an
X is present in a range of cells please?

a b c d
1 tim
2 pete x
3 jo x

for example how to make tim black and pete in red because of c2 and jo
in red because of d3

thanks

K

Hi Karen,

Select Column A or Select all cells (Ctrl+A) depending
on which cells you want to be colored.

As long as Row 1 has the active cell then\

Format, Conditional Formatting
C.F. Formula Is: =COUNTIF($B1:$G1,"x")
then click on the formatting button, patterns (tab), choose color

More information on Conditional Formatting in
Conditional Formatting
http://www.mvps.org/dmcritchie/excel...t.htm#multiple
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"*k*" wrote in message news
how do i change the color of a cell (red or black) depending on if an
X is present in a range of cells please?

a b c d
1 tim
2 pete x
3 jo x

for example how to make tim black and pete in red because of c2 and jo
in red because of d3

thanks

K

excellent, thanks i will go have a look :-) appreciate the help.
K

On Thu, 10 Jun 2004 01:43:15 -0400, "David McRitchie"
wrote:

Hi Karen,

Select Column A or Select all cells (Ctrl+A) depending
on which cells you want to be colored.

As long as Row 1 has the active cell then\

Format, Conditional Formatting
C.F. Formula Is: =COUNTIF($B1:$G1,"x")
then click on the formatting button, patterns (tab), choose color

More information on Conditional Formatting in
Conditional Formatting
http://www.mvps.org/dmcritchie/excel...t.htm#multiple
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"*k*" wrote in message news
how do i change the color of a cell (red or black) depending on if an
X is present in a range of cells please?

a b c d
1 tim
2 pete x
3 jo x

for example how to make tim black and pete in red because of c2 and jo
in red because of d3

thanks

K