LinkBack URL
About LinkBacks
Can a conditional format be created using time i.e 1:00 PM? What I am trying to do is if the entry of cell I7 (formatted entry as h:mm AM or h:mm PM) is less than 7:00 AM turn the font red and if it is after 7:00 PM do the same. Thanks.
Can a conditional format be created using time i.e 1:00 PM? What I am trying to do is if the entry of cell I7 (formatted entry as h:mm AM or h:mm PM) is less than 7:00 AM turn the font red and if it is after 7:00 PM do the same. Thanks.
Last edited by Foxcan; 06-23-2009 at 02:55 PM.
Hi,
Try something like this
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks