Conditional Format Brain Fart

[bobgrand]

Hello all,

I am struggling with what I think should be pretty simple. I checked around for examples and still stumble. Please help.

Column C has a number
Column W has a number

I need the cell in column W to highlight if it does not equal column C

Both of these columns should be equal.

[TABLE="class: grid, width: 300"]
<tbody>[TR]
[TD="align: center"]C[/TD]
[TD="align: center"]W[/TD]
[/TR]
[TR]
[TD="align: center"]45[/TD]
[TD="align: center"]45[/TD]
[/TR]
[TR]
[TD="align: center"]60[/TD]
[TD="align: center"]50[/TD]
[/TR]
[TR]
[TD="align: center"]80[/TD]
[TD="align: center"]80[/TD]
[/TR]
[TR]
[TD="align: center"]45[/TD]
[TD="align: center"]65[/TD]
[/TR]
</tbody>[/TABLE]

Any help would be greatly appreciated

Bob

 

[Fluff]

Select W2:W last row & use this formula
=W2<>C2

 

[bobgrand]

Fluff,

That did not work. I highlighted column W8 thru W80, put that formula in the conditional format and everything highlighted red.

Bob

 

[Fluff]

If the first cell is W8 then you need to use
=W8<>C8

 

[bobgrand]

I did change the cell numbers. Everything is highlighting red.

 

[Fluff]

That would suggest that nothing in W matches C, are the numbers entered manually or by formula?
If formula check for decimals.

 

[bobgrand]

So sorry. I think this may be the problem.

The number in column C is derived by the following formula. I think the number in column C is not showing up as an actual number.

=IF(A8="","",MID(A9,1,FIND(" ",A8)))

 

[Fluff]

In that case change the formula to
=IF(A8="","",MID(A9,1,FIND(" ",A8))*1)
It will convert them into numbers

 

[bobgrand]

Sweet, Thank you so much. That worked.

Have a great day

 

[Fluff]

Glad to help & thanks for the feedback