How to change colors to time values

Ashikido · #1 02-01-2021, 11:35 AM

Quote:

Originally Posted by p45cal

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Change Standard Colors in Powerpoint (not	munichone	PowerPoint	3	07-02-2024 12:47 PM
Merging 2 different cells containing IF formula & change in cell values based on multiple time frame	jay_excel	Excel	0	07-29-2017 11:04 PM
Track Change & Reviewer Colors	mdarner	Word	1	05-27-2015 11:09 AM
Setting specific values to colors	macitaa	Excel	2	03-26-2015 11:54 AM
Unable to change font colors from theme colors	choy	Word	3	08-01-2012 09:12 PM