Check cells using Marcos

[mygamemyrule]

Its kind of complex operation and that is why I request some help.

I want to develop a macros which will add filter in all coloumn then going to check all coloumn 1 by 1 if it find FALSE , It will change the cell colour to RED. It will create another sheet and will paste all the details of that False row. If there is no false in the column it will leave it as it is.

I am adding a dummy sheet for more clearence.​

Excel Help Forum

Any help will be appreciated

 

[Fluff]

Cross posted
Check cells using Marcos

 

[mygamemyrule]

tried but not helpful

 

[Fluff]

Please read Excelguru Help Site - A message to forum cross posters