change color of cell if an X exists in range

[*k*]

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

 

[David McRitchie]

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/condfmt.htm#multiple

 

[*k*]

excellent, thanks i will go have a look appreciate the help.
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/condfmt.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

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