Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Conditional Formating Time
I have various deadlines and I have formatted my cells to have a Green background if the deadline is met. So the first condition is "Less than or Equal to." The cell turns red if the deadline isn't met, so the condition is "Greater than." I would type in 12:51 as the conditional value and not worry about a.m or p.m. The numbers are converted to something like 0.03546666. Things have been going along great until I got into early a.m. times, but now I'm having problems. If I type in 12:51 as the conditional value and 11:20 as the actual I should get a green background, but I'm getting red. It doesn't seem as if AM or PM should make a difference in the outcome, but something strange is going on. I tried formatting the actual time as PM, but that didn't make a difference. Thanks for any help. -- jonhunt ------------------------------------------------------------------------ jonhunt's Profile: http://www.excelforum.com/member.php...o&userid=35370 View this thread: http://www.excelforum.com/showthread...hreadid=561199 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formating - wildcards | Excel Worksheet Functions | |||
Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
Conditional formating using formulas | Excel Worksheet Functions | |||
can i freeze conditional formating to copy to another worksheet | Excel Discussion (Misc queries) | |||
Conditional Formating | Excel Discussion (Misc queries) |