Compare value in one column with another

[ipbr21054]

Morning,
Working with numbers & having to make a large list.
Before i make a large mistake can you advise a basic code for me please.

The columns in question are W & X
The code will check the number value in the first cell in column W & make sure its the same as in the cell to the right.
The code will check all down my list.

Is the value matches then leave as is BUT if value does not match make cell in column X red


IF NO VALUE IN CELL COLUMN W THEN JUST MOVE ON

Thanks

 

[myall_blues]

You can do this with conditional formatting. Highlight the cells in column X, then choose Conditional Formatting->New Rule->Use a formula...
The formula to apply is

=AND(X1<>W1,NOT(ISBLANK(W1)))

Change the row number to match the first row of your highlighted range. Set the format as you want it to appear.

Book1
	W	X	Y
1	1	1
2	2	3
3	3	3
4
5	4	4
6	5	6
7		2
8	6	9
9	7	7
10
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
X1:X9	Expression	=AND(X1<>W1,NOT(ISBLANK(W1)))	text	NO

Regards

Murray

 

[ipbr21054]

I dont understand the second part where you show X1:X9

 

[ipbr21054]

I now have it working but shows lots of errors where i can see the number is the same but im told its different.

 

[myall_blues]

I dont understand the second part where you show X1:X9

That was just to show you an example of it working.

I now have it working but shows lots of errors where i can see the number is the same but im told its different.

Are you sure the numbers really are the same? As a test, I’m column Y where it is telling you they are different but they look the same (for example I will assume it is row 20) then in column Y put the formula

=W20=X20

If the two numbers are really the same it will show TRUE, if not it will show FALSE.

 

[ipbr21054]

Yes im sure,im looking at a different way now thanks as need to do it manually & leave quickly.

Thanks for reply