#1
|
|||
|
|||
Conditional formatting of a cell
Hi. I wish to create a condition on which cells turn red if there is a difference in value between two other cells. Specifically, it is a time difference.
ie: A shift begins at aa:bb (hours:minutes). Patient x arrives at aa:bb. If the difference between the beginning of the shift and the arrival time is longer than 12 hours, cell x will turn red (so as to notifiy us that said patient has been for longer than 12 hours without being hospitalized). Best regards. Claudio |
#2
|
|||
|
|||
Can it happen that shift begins for example at 6:00 PM and patient arrives at 1:00 PM so that arrive hour is less than start hour?
|
#3
|
|||
|
|||
Deleted again.
|
#4
|
|||
|
|||
Maybe like this.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Question re: Conditional formatting (cell occurs after another cell) | Saywarder | Excel | 1 | 04-20-2015 11:29 AM |
Conditional Cell Formatting: Alternating Cell Checks | corbott | Excel | 4 | 12-16-2014 01:51 PM |
Conditional Formatting based on Value of Another Cell | SteveBump | Excel | 3 | 03-07-2014 09:16 AM |
Conditional formatting value change of same cell | tcalhoun | Excel | 0 | 04-25-2013 07:25 AM |
How can I fill cell color starting from Cell D5 using Conditional formatting instead | Learner7 | Excel | 0 | 07-08-2010 05:50 AM |