Code To Highlight Cells With Date Errors

[Dazzawm]

I have a large data file like below. I have a data column where there are errors where the end date is before the start date! I need a code please to highlight these.

StartEndDate

11/2013->12/2014

11/2013->02/2018

03/2013->11/2013

01/2017->12/2014

11/2013->02/2018

05/2013->11/2013

01/2017->12/2014

I have highlighted above what sort of format and errors occur. There are various columns of data either side but I can adapt the code to the column it needs to look at in each different file I use it on.

Thanks

 

[etaf]

i have used
=DATEVALUE("1/"&LEFT(A2,7)) > DATEVALUE("1/"&RIGHT(A2,7))

in a conditional formatting rule

Book4
	A	B	C	D
1	StartEndDate
2	11/2013->12/2014		41974	41579
3	11/2013->02/2018
4	03/2013->11/2013
5	01/2017->12/2014	?
6	11/2013->02/2018
7	05/2013->11/2013
8	01/2017->12/2014	?
Sheet2

Cell Formulas
Range	Formula
C2	C2	=DATEVALUE("1/"&RIGHT(A2,7))
D2	D2	=DATEVALUE("1/"&LEFT(A2,7))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:A8	Expression	=DATEVALUE("1/"&LEFT(A2,7)) > DATEVALUE("1/"&RIGHT(A2,7))	text	NO

 

[Dazzawm]

I would prefer a macro if one is possible so I can put in my PMW for different files.

 

[etaf]

not my area , my VBA is now to old

perhaps report this post and ask moderator for it to be closed

and then open a new one specifically asking for VBA in the title

 

[Dazzawm]

not my area , my VBA is now to old

perhaps report this post and ask moderator for it to be closed

and then open a new one specifically asking for VBA in the title

Thanks but I did ask for code and not formula.

 

[Dazzawm]

Can anyone help with this please?

 

[Dazzawm]

I guess not!