How to know if a column contains cells that do not respect the column type (red cells)?

without scrolling the entire data set

1 Like

Use the ISERROR function, i.e. add a formula ISERROR($col) and then you can look for where that formula returns true, e.g. with a column filter or a summary table.