Conditional Formatting

[technofrank]

Hi All,

Please help me about conditional formatting, suppose I will type an exact word or value "TEST" in cell B2. Is there a way after typing the word "TEST" in cell B2 the cells from A2 to F2 will change to my desired fill color?

I know there's a way out here please help.

I am using MS OFFICE 2007

Thank you in advance.

 

[Sixthsense]

In the Color box, select Red. In the Font Style box, select Bold.Click OK until the dialog boxes are closed.

1. Select cells A2:F2.
   
   
2. Then, click Home > Conditional Formatting > New Rule.
   
   
3. In the New Formatting Rule dialog box, click Use a formula to determine which cells to format.
   
   
4. Under Format values where this formula is true, type the formula: =COUNTIF($A$2:$F$2,"Test")
   
   

Apply your desired formatting

 

[technofrank]

WOW! Thank You!! Fast and accurate reply! Problem Solved!

 

[technofrank]

Sorry I have another question, what if in any cell under column B if i put the word test their corresponding rows will be automatically change to my desired fill color.

for example if I type test in B3 the cell A3 to F3 will change color to blue;
if I type test in B6 the cell A6 to F6 will change color to blue;
if I type test in B10 the cell A10 to F10 will change color to blue;

Thank you in advance

 

[Sixthsense]

Follow the same steps mentioned in Post #3 but select the range and proceed.

change the Post #2 formula with the below one.

=COUNTIF($A2:$F2,"Test")

 

[technofrank]

It's working but there's a flaw, for example if i type test in any cell inside the range that i selected the conditional formatting will still work. Is there any way that only cells in column B will accept the conditional formatting, because I tried to type test in B2 it works and I tried to type test in C2 it will still work.

Thank you in advance

 

[Sixthsense]

I regret for the inconvenience.

Replace the provided formula with the below one

=$B2="Test"