highlight dates in Cells, and prevent the use of dates in a Column

[drom]

Hi and thanks in advance!

I have a column were I have to put PAX, son numbers bigger than 0

I am doing this this with:

• Data validation/Allow = Whole Number/Data = Grater than/Minimun =0

And I am formatting the cells to highlight in RED cells were the values are:

• =ISTEXT(A8) 'TEXT
• =A8<=0 'negative values
• =A8="" 'Blank cells

Works OK, I guess I could use just 1 formula to highLight those cells anyway...

Some Times Some users are introducing Dates in this Column (Column A)
So, the DataValidation does not Work
and the Conditional Formatting does not work (or Works but OK, because I am missing to avoid Dates)

Any Help to avoid using Dates in this cells ??
and to HighLight if I put dates (eg: using VBA, Activecell="5-5")

 

[Leo Skywalker]

What is the biggest number you can have in column A?