Thread: How to change colors to time values
View Single Post
 
Old 02-01-2021, 11:35 AM
Ashikido Ashikido is offline Windows 10 Office 2019
Novice
  
Join Date: Dec 2019
Posts: 6
Ashikido is on a distinguished road
Default
Quote:
Originally Posted by p45cal View Post
Make one of the formulae:
=AND(MOD($B2,1)>=9/24,MOD($B2,1)<=17/24)
and the other:
=AND(MOD($B2,1)>17/24,MOD($B2,1)<1)
[actually, that second formula can be simplified to =MOD($B2,1)>17/24, untested]


edit post posting: Oops. I've just noticed the attached file was Arvi's and not the OP's! Sorry. And it would help if I read the question properly! Updated.
Thank you, this is useful. i realized that in the conditional formatting section I was picking "format only cells that contain" instead of "Use a formula... ).
Reply With Quote