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
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