Excel macro to compare values

I need your help I wanted to know is there any vba script to get my job done easier As of now I'm working with IF and AND conditions I would like to have it changed with a macro So I can selected the range and covert to "1" and "0"

All I need to do is compare the values in the every column with the right answer in 1 cell of every column Mark 1 for match 0 for no match

Thank you Any help will be great full enter image description here