| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting Times
Cell A1 is expected finish time of 11:50 PM. Cell A2 is actual finish time.
I need to conditionally format cell A2 to show green if finished on or ahead of time, show yellow if finished between ontime and 10 minutes late, and red anything later than 10 minutes late. The times often go into the next day. An example of a finish time is 12:40 AM which I need to show as red. Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting comparing times | Excel Worksheet Functions | |||
| Excel 2007 Conditional formatting - change text colour when enteringsame name more than 3 times | Excel Discussion (Misc queries) | |||
| Conditional Formatting for times | Excel Discussion (Misc queries) | |||
| Formatting Times In Excel | Excel Worksheet Functions | |||
| Formatting values to be Times of day... | Excel Discussion (Misc queries) | |||
![kimberlyd.[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
