Conditional Formatting Issue

[MN_Excel]

I am attempting to format data in particular columns. If the cell in C2 doesn't equal the value in B2 I would like C2 to be yellow, if it does equal B2 I don't want any formatting. I've worked through the conditional formatting options, but have been unable to find a solution. Any ideas?

 

[T. Valko]

I am attempting to format data in particular columns. If the cell in C2 doesn't equal the value in B2 I would like C2 to be yellow, if it does equal B2 I don't want any formatting. I've worked through the conditional formatting options, but have been unable to find a solution. Any ideas?

What version of Excel are you using?

 

[MN_Excel]

2007

 

[T. Valko]

2007

Try this...

• Select cell C2
• Goto the Home tab>Styles>Conditional Formatting>Manage rules>New rule>Use a formula to determine which cells to format
• Enter this formula in the box below: =C2<>B2
• Click the Format button
• Select the desired style(s)
• OK out

 

[MN_Excel]

Thanks, that almost gets me there. Now my issue is that when I try and copy the format down to rows 3, 4, etc it continues to use row 2......in short, I'm looking to copy the formula down

 

[T. Valko]

Thanks, that almost gets me there. Now my issue is that when I try and copy the format down to rows 3, 4, etc it continues to use row 2......in short, I'm looking to copy the formula down

Ok, if you want to format a RANGE of cells...

Let's assume you want to format C2:C10.

Select the *entire* range C2:C10 starting from cell C2. Cell C2 will be the active cell. The active cell is the one cell in the selected range that is not shaded. The formula will be relative to the active cell.

Then follow the steps to apply the format.

 

[MN_Excel]

Unfortunately I think I took a step backward in my understanding. In my example I don't want the formatting to be contigent on one cell. See example below.......the 4th and 6th lines in column B would be yellow because they are different than column A. The others, which are the same, would have no formatting. Thanks for your patience.

Column A Column B
1 1
2 2
1 1
1
1 1
1

 

[T. Valko]

Unfortunately I think I took a step backward in my understanding. In my example I don't want the formatting to be contigent on one cell. See example below.......the 4th and 6th lines in column B would be yellow because they are different than column A. The others, which are the same, would have no formatting. Thanks for your patience.

Column A Column B
1 1
2 2
1 1
1
1 1
1

Hmmm...

What I suggested does what you asked for.

 

[MN_Excel]

Sorry for the confusion...I think I got it. Thanks for your help!

 

[T. Valko]

Sorry for the confusion...I think I got it. Thanks for your help!

Good deal. Thanks for the feedback!