Check for Error

[chiswickbridge]

Hi Guys,

I have a databases of Passport Numbers / Credit Card Numbers / Etc, with 1000 rows and 60 columns, starting in A1.

I just need to know of a method when I type the Passport or credit card numbers, which will tell me that the data input the second time or the first time is wrong or there is a mismatch....eg....

So, I decided to type the Passport Number / CDC number twice in adjoining columns, the second column has an Alarm1 and Alarm2.
[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"]A1[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]ALARM 1[/TD]
[TD][/TD]
[TD="align: center"]ALARM 2[/TD]
[/TR]
[TR]
[TD]Serial Number[/TD]
[TD]Name[/TD]
[TD]passport number 1[/TD]
[TD]passport number 2[/TD]
[TD]cdc number 1[/TD]
[TD]cdc number 2[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]John[/TD]
[TD]A123456[/TD]
[TD]A123456[/TD]
[TD]X123456[/TD]
[TD]X123456[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Rob[/TD]
[TD]B123456[/TD]
[TD]B123456[/TD]
[TD]Y123456[/TD]
[TD]Y123456[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Wilf[/TD]
[TD]C123456[/TD]
[TD]C123456[/TD]
[TD]Z123456[/TD]
[TD]Z123456[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Pat[/TD]
[TD]D123456[/TD]
[TD]D123444[/TD]
[TD]V123456[/TD]
[TD]V123444[/TD]
[/TR]
</tbody>[/TABLE]

I have typed 3 rows correctly, in the 4th Row, I have deliberately typed wrong data.

Need a VBA or a formula to change the Fill colour to RED in the cells containing Alarm1 and Alarm2. This will tell me there is a mismatch. So I can correct the same.

To input data, I will go sequentially, meaning 1 to 1000, so when I reach row 36.... I know for sure, my earlier 35 rows data is absolutely correct. I will split the page so the Alarm will always be visible at the top.

Hope I am very clear in my query....

Thanks for your time...

 

[Michael M]

You could use conditional formatting for this
Highlight from D3 downwards
Click on Home Tab / conditional formatting button
Select New Rule
Select Use formula to determine cells to format
In the formula box type =C3<>D3
Format to suit
Ok to all that
Repeat for Column F

 

[chiswickbridge]

That was a real Quickie......even better...... Thank You DONE.....