Highlighting of the hour range

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.

One way, using this as the CF formula:

=AND(-LOOKUP(1,-LEFT(C$1,ROW($1:$3)))>=$A$3,-LOOKUP(1,-LEFT(C$1,ROW($1:$3)))<=$B$3)

EDIT - Ignore , already answered with a better solution then mine

are you just putting one set of entries into the sheet

I have a way of doing it - but it will need a change from 23-0 to be 24-24
is that acceptable

so using a formula
=AND($A3<=LEFT(C$1,FIND("-",C$1,1)-1)*1,$B3>=RIGHT(C$1,CHOOSE(LEN(C$1),0,0,0,0,1,2,2))*1)

in conditional formatting


OR did you want the ROW with the times highlighted

Pictures are different to sample sheet
and no expected results

if you want the row that you enter the data to be used
same formula just a different way to apply

theres a lot of working , showing the development of the formula
and then the formula also in row3 - which isnt necessary - BUT shows the true/false how cond frmt would see it

Formula modified and is found here.. with any cell(s) in the block C2:Z62 selected

Home/Styles/Conditional Formatting/Manage Rules/edit rule.

Did you want this applied to the bLOCK or on a row-by row basis??

You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please select "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.