i am using the mullins steel boat example(conditional formatting) as the base for the following:
code start end 19:00 19:10 19:20
48 20:00 20:30
39 20:30 20:45
31 20:45 21:50
39 21:50 22:00
43 22:00 22:20
where a user enters a code and the the start and end time, then bars are highlighted corresponding with the block of time represented (using the conditional formula =AND(D$1>=$B2,D$1<=$C2)). what i want is for the user to enter a coded start and end and then display the corresponding time block on a single line, color coded by code. so mabey code 31 is yellow, and 48 is green. the times will not overlap, but there may be gaps between one codes end and the next sequential start.
thanks,
eric
code start end 19:00 19:10 19:20
48 20:00 20:30
39 20:30 20:45
31 20:45 21:50
39 21:50 22:00
43 22:00 22:20
where a user enters a code and the the start and end time, then bars are highlighted corresponding with the block of time represented (using the conditional formula =AND(D$1>=$B2,D$1<=$C2)). what i want is for the user to enter a coded start and end and then display the corresponding time block on a single line, color coded by code. so mabey code 31 is yellow, and 48 is green. the times will not overlap, but there may be gaps between one codes end and the next sequential start.
thanks,
eric