How to highlight a certain time range

[RichTom44]

Hi, How to highlight the cells within a time range from 1-minute to 5-minute intervals? As shown below sample. Thanks

Date and Time
31/10/2023 04:06 PM
17/10/2023 09:11 AM
15/10/2023 03:00 PM
15/10/2023 03:01 PM
02/10/2023 08:09 PM

 

[SanjayGMusafir]

Check this and revert -

Book1
	A
1	10/31/23 16:06
2	10/17/23 9:11
3	10/15/23 15:00
4	10/15/23 15:01
5	10/2/23 20:09
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A:A	Expression	=OR(AND(A2>=A1+(1/1440),A2<=A1+(5/1440)),AND(A1>=A1048576+(1/1440),A1<=A1048576+(5/1440)))	text	NO

 

[RichTom44]

Hi, it works perfectly. Thanks

 

[SanjayGMusafir]

Glad to help you and thanks for the feedback.