#1
|
|||
|
|||
How to change colors to time values
Hi, I have a table with time zones, see png. I would like to format the table so that the local date time would show in green when, for example, it is between 9am and 5pm, and in the red after 5pm until 11.59pm. How can I do this? I tried with conditional formatting but for some reason I cannot get it to work. Thanks |
#2
|
|||
|
|||
Please add a workbook and not a picture as we just have to waste time recreating somthing that already exists
|
#3
|
|||
|
|||
Something like this?
|
#4
|
||||
|
||||
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. |
#5
|
|||
|
|||
Exactly. How did you manage to do that? EDIT: Oh, I see, with a formula. |
#6
|
|||
|
|||
Quote:
|
#7
|
|||
|
|||
Good advice. I hadn't thought about that.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |
Change Standard Colors in Powerpoint (not | munichone | PowerPoint | 1 | 02-27-2015 07:11 AM |
Unable to change font colors from theme colors | choy | Word | 3 | 08-01-2012 09:12 PM |