# Conditional Format Brain Fart

#### bobgrand

##### Board Regular
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.

 C W 45 45 60 50 80 80 45 65

<tbody>
</tbody>

Any help would be greatly appreciated

Bob

#### Fluff

##### MrExcel MVP, Moderator
Select W2:W last row & use this formula
=W2<>C2

#### bobgrand

##### Board Regular
Fluff,

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

Bob

#### Fluff

##### MrExcel MVP, Moderator
If the first cell is W8 then you need to use
=W8<>C8

#### bobgrand

##### Board Regular
I did change the cell numbers. Everything is highlighting red.

#### Fluff

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

#### bobgrand

##### Board Regular
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

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

#### bobgrand

##### Board Regular
Sweet, Thank you so much. That worked.

Have a great day

#### Fluff

##### MrExcel MVP, Moderator
Glad to help & thanks for the feedback

1,082,371
Messages
5,365,066
Members
400,821
Latest member
kezza123

### This Week's Hot Topics

• populate from drop list with multiple tables
Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
• Find list of words from sheet2 in sheet1 before a comma and extract text vba
Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
• Dynamic Formula entry - VBA code sought
Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...