Check cell format is Date or Time

Hello,

I am not an expert in VBA and I would appreciate some help with a problem I am trying to solve.

I have a table where I have information of various products (A1:C14). I would like to insert a VBA code to automatically check if the information inserted in column B has the Date format (dd-mm-yyyy) and if the information inserted in column C has the Time format (hh:mm:ss), if the format is not the same the cell's fill colour should change to red.

I adapted a code from the net, but the result is not the ideal, the blank cells also change the background to red.

Any suggestions would be greatly appreciated

Thank you in advanced.