Conditional Formatting Date/Time within 30 minutes of each other

[eli_m]

Hi,

I currently have this Formula in column AY:

=IF([@[Planning Date]]="N/A","",
IF(ISFORMULA([@[Planning Time]]),"",
CONCATENATE(TEXT([@[Planning Date]],"dd/mm/yy")," ",TEXT([@[Planning Time]],"hh:mm am/pm"))))

and these two conditional formattings to turn red when there is a clash in times that are 29 minutes of each other:

=AND(ROW()>1, ABS($V3-$V2)*1440<29,$AX3="No",COUNTIF($AQ3,"Planning Time Approved*")=0)

=AND(COUNTIF($AY$3:$AY$200,V3)>1,NOT($AY3=""),COUNTIF($AQ3,"Planning Time Approved*")=0,$AX3="No")

but for some reason only one of the times goes red:

How can I make it so both of them turn red?

Thanks in advance!

 

[Peter_SSs]

How is this question different to this one?

 

[eli_m]

How is this question different to this one?

I thought it was a little different hence why no one answered so I thought I’d try my luck again

 

[Peter_SSs]

Seems to me it is basically identical so I have closed the other thread per #12 of the Forum Rules

 

[eli_m]

Seems to me it is basically identical so I have closed the other thread per #12 of the Forum Rules

Thanks - hope we can close this one off too when there’s a solution