enter in C2
=IF(B2-A22,1,"")
and copy down

--
Greetings from New Zealand
Bill K
"Timmy" wrote in message
...
If the value of column B is greater by 2 than the value of column A,
Record
as 1 in column C.