Need to verify Bad Dates & Empty values & '0' Values in different columns

I appreciate anyone's help on my issue.

I have excel sheet where i would like to find the following:

1) bad dates (should not be less than 1900 and not greater than current date) in columns that contains date values
2) finding the empty cells in an column that contains data like amount e.t.c
3) finding the cells which contains '0' values in the column.

I have multiple excel sheets to work on where i need to run all the above queries in each sheet.

dmrao kanuri