|
|
#1
01-31-2021, 01:12 PM
|
|||
|
|||
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 
|
|
|
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