change color of cell if an X exists in range

  • Thread starter Thread starter *k*
  • Start date Start date
K

*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
 
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
 
Back
Top