|
|
#6
02-01-2021, 09:14 AM
|
||||
|
||||
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. 
|
|
|
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 |
Windows 10 
Office 2019
Threaded Mode