LinkBack URL
About LinkBacks
Woo Woo! Glad I could help out.
It was conditionally formatted to
=AND($C$3>=TRIM(MID(SUBSTITUTE(B15," - ",REPT(" ",100)),1,100))*1,$C$3<=TRIM(MID(SUBSTITUTE(B15," - ",REPT(" ",100)),100,100))*1)
Where C3 was the value you're looking up
Woo Woo! Glad I could help out.
It was conditionally formatted to
=AND($C$3>=TRIM(MID(SUBSTITUTE(B15," - ",REPT(" ",100)),1,100))*1,$C$3<=TRIM(MID(SUBSTITUTE(B15," - ",REPT(" ",100)),100,100))*1)
Where C3 was the value you're looking up
Last edited by daffodil11; 10-31-2013 at 12:34 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks