If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
change color of cell if an X exists in range
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 |
#3
|
|||
|
|||
change color of cell if an X exists in range
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 |
Thread Tools | |
Display Modes | |
|
|