Validate Cells based on if conditions

  • Thread starter Thread starter Supriya
  • Start date Start date
S

Supriya

I have 4 cells where the first 2 cells are call log date & time.
The next 2 cells are call responded date & Time.

I need to validate the cell containing Responded Time in such a way
that,
If Call Log Date & Call Responded Date are same, Then
Call Responded Time> Call Log Time.
Else If Call Responded Date> Call Log Date Then
Call Responded Time< Call Log Time or > Call Log time or = Call Log
Time

How to do this?
 
Hi,

I was able to validate on my own. Let me share it.

If A & B columns has Call Log Date & Time
Collumn C & D has Responded Date & Time
Then D can be validated ad follows

Go to data validation, Select custom and enter the formula
=IF(C1=A1,D1>B1,OR(D1<B1,D1>B1,D1=B1))
This can be copied to the rest of the rows as well
 
Back
Top