I'm using conditional formatting to highlight time based on user input. I want the colored bar to reflect time in 15 minute increments, unfortunatly I don't know how to make it work without being off one one side or the other. I doubt I've explained myself clearly and apologize.
[IMG="http://www.excelforum.com/attachment.php?attachmentid=17293&stc=1&d=1198408694"]http://www.excelforum.com/attachment.php?attachmentid=17293&stc=1&d=1198408694[/IMG]
Last edited by sharkey; 12-23-2007 at 07:21 AM. Reason: Add picture again
This conditional formatting formula worked for me.
Select D2 and enter this as the formula. paste the format to the other cells.
=AND($B$3<=($D$1+TIME(0,15*(COLUMNS($D$1:D1)-1),0)),($D$1+TIME(0,15*(COLUMNS($D$1:D1)-1),0))<$C$3)
Last edited by mikerickson; 12-24-2007 at 01:16 AM.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
You're a genius.
I changed the formula to
and it works great
=AND($B$2<=($D$2+TIME(0,15*(COLUMNS($D$2:D2)-1),0)),($D$2+TIME(0,15*(COLUMNS($D$2:D2)-1),0))<$C$2)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
sharkey 
Register To Reply
Bookmarks