View Single Post
 
Old 12-08-2016, 10:54 AM
corsair_lancer corsair_lancer is offline Windows 10 Office 2016
Novice
 
Join Date: Oct 2016
Posts: 2
corsair_lancer is on a distinguished road
Default 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
Reply With Quote