Hello my Excel friends,
I'd greatly appreciate your assistance resolving this. I've tried so many different ways . . .
I am determining a range of time and need the CF (Conditional Formatting) to make the cell red if a range is exceeded.
I've put the 0:09 in single quotes, double quotes, no luck.
Please Login or Register to view this content.
Thanks in advance for your wise suggestions.
Last edited by GregM56; 03-31-2017 at 06:52 PM. Reason: Sorry, typo for this post, it's B1-A1.
Using the values and formulas in the cells you specify, the result in C1 is 0:00 which is not greater than 0:09.
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
Sorry for the typo in the post. I've corrected it. I didn't make the same mistake on the spreadsheet. The result shows 0:19, but NOT in Red.
Thanks
Ok, I am having the same issue with the IF formula, not sure why. Have you tried the conditional formatting menu in the home tab and selecting Highlight cell rules then select Greater than? It works that way.
Is that 9 minutes or 9 seconds?
=C1>timevalue("00:09:00")
0r
=C1>TIMEVALUE("00:00:09")
Ben Van Johnson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks