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

Hi and welcome to the forum

to begin with, ALL of your data is text, even those that look like dates. You 1st need to remove all the ^'s do this using Find/Replace. Find ^ replace with nothing.

Now you have data to work with. What do you want done if the criteria you set are found? (a date cannot be before 1/1/1900 anyway)

You would use Conditional Formatting for this.

1. highlight the range you want to apply the conditional formatting to
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =$C2>TODAY()

5. select new rule, select format cells that contain
6. select Blanks

I amd confused by this one...

2) finding the empty cells in an column that contains data like amount e.t.c

empty cells dont contain anything - what exactly is the criteria here?


=$A$2:$H$11