Check and identify duplicate entries

[adzygore]

I have a data sheet in which I have to check for multiple entries in 2 or more columns. I have inserted a blank column after every such Group of columns. If a red mark cell should appear in the corresponding row for multiple entries it could save a lot of time in identifying them. There are about 800 such columns. Please go through the attached sheet​

​

 

[tommyt61]

You can use conditional formatting that uses a countif formula to count how many 1's have been entered . if the count is more than one it flags that row red, just like in your posted worksheet.

=COUNTIF($B2:$F2,"1")>1 ,,,, this is for checking religion

=COUNTIF($H2:$I2,"1")>1 ,,,, this is for Gender