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.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Thank you Ali.
I have attached excel file.
Br
Andrew
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)
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
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
Last edited by etaf; 01-22-2022 at 12:37 PM.
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Hi Wayne,
Thanks for your help!
br
Andrew
Hi Glenn, Thanks you very much for your tip.
Could you please also clarify me in below questions?
Where can I see this CF formula in spreadsheet.
What should I change in this formula because now I see one hour too much( I set 10-15 and see range 10-16)
Attachment 764887
br
Andrzej
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??
Glenn, now I know everything and works properly.
Thanks
Br
Andrzej
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Highlighting of the hour range
Register To Reply
Bookmarks