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