Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-08-2016, 10:54 AM
corsair_lancer corsair_lancer is offline Conditional formatting of a cell Windows 10 Conditional formatting of a cell Office 2016
Novice
Conditional formatting of a cell
 
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
  #2  
Old 12-09-2016, 10:37 PM
xor xor is offline Conditional formatting of a cell Windows 10 Conditional formatting of a cell Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

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?
Reply With Quote
  #3  
Old 12-10-2016, 01:33 AM
xor xor is offline Conditional formatting of a cell Windows 10 Conditional formatting of a cell Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

Deleted again.
Reply With Quote
  #4  
Old 12-10-2016, 01:34 AM
xor xor is offline Conditional formatting of a cell Windows 10 Conditional formatting of a cell Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

Maybe like this.
Attached Files
File Type: xlsx Shift.xlsx (10.0 KB, 7 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional formatting of a cell 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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:25 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft