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.

A1			ALARM 1		ALARM 2
Serial Number	Name	passport number 1	passport number 2	cdc number 1	cdc number 2
1	John	A123456	A123456	X123456	X123456
2	Rob	B123456	B123456	Y123456	Y123456
3	Wilf	C123456	C123456	Z123456	Z123456
4	Pat	D123456	D123444	V123456	V123444

<tbody>
</tbody>

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.....