Excel Data Validation of Formatted Time not working

[wezuk03]

Hello,

I am creating a weekly room booking sheet, and I want to make it clear to users when they input a time that if it starts before the end of the previous time, then a warning will pop up. Using data validation, this should be relatively easy.

However, I can't seem to get it to work. The data validation of cell B2 says that if the time in it's cell is less than or equal to cell A1, then to show a warning. However, when I input a time that is less than or equal to A1, it doesn't throw any warning.

If I set the data validation to just equal to cell A1, it does work if I put the same time in B2

What am I doing wrong here?

Thanks!

 

[Jonmo1]

Welcome to the board

The data validation of cell B2 says that if the time in it's cell is less than or equal to cell A1, then to show a warning.

You have the logic of data validation reversed.

Validation will Allow the entry of a value when the Criteria IS Satisfied.
The Validation Message will be shown (and entry not allowed) when the value entered does NOT satisfy the criteria.

 

[wezuk03]

Wow... I am an idiot!

Thanks for your swift response

 

[Mike54]

Howabout

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Range("B1") <= Range("A1") Then
MsgBox "Check Time Please"
End If
End Sub

In VBA

 

[Jonmo1]

You're welcome.

 

[kvsrinivasamurthy]

Validate both A1 and B2 cells.