Highlight a timestamp if within a time of another timestamp

[Paul365]

Hello,

I am trying to conditional format a spread sheet with time stamps on it. I am looking to have...
Start time 'Cell A1'and in Cell A2 and A3 some other time stamps with different times.
I would like all cells except A1 to highlight different colors if they are within a certain time of A1
example: A1 12:05 PM
- If the other cells times are under 1 hour of A1, I would like them to turn green,
- If the other cells are between 1 and 2 hours of A1 to turn Orange
- If the other cells are 2+ hours of A1 to turn Red.

I have looked up so many website and all I get is formula's with dates or the current time, not a previous time.

If anyone can help would be much appreciated

Thanks

 

[Eric W]

Welcome to the MrExcel forum!

Start by formatting A2 and A3 with a green fill color. Then set up your Conditional Formatting like this:

Book1
	A
1	12:05 PM
2	10:55 AM
3	2:24 PM
Sheet4

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:A3	Expression	=ABS($A$1-A2)>2/24	text	NO
A2:A3	Expression	=ABS($A$1-A2)>1/24	text	NO

 

[Paul365]

Welcome to the MrExcel forum!

Start by formatting A2 and A3 with a green fill color. Then set up your Conditional Formatting like this:

Book1
	A
1	12:05 PM
2	10:55 AM
3	2:24 PM
Sheet4

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:A3	Expression	=ABS($A$1-A2)>2/24	text	NO
A2:A3	Expression	=ABS($A$1-A2)>1/24	text	NO

This is perfect, Thankyou so much