Conditionl Formating to highlight time slots between start and Finish time.
Hello,
This question has probably been asked before, I have a booking schedule with time slots, I would like a selection of cells to highlight between the start and end time. I have attached an example of what I am looking to do. currently i am manually highlighting the time slots, i would like it to auto fill when i enter the times.
Please help?
Thanks in advanced
Hi, welcome to the forum
1. highlight the range you want to apply the conditional formatting to
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =AND(D$3>=$B4,D$3<=$C4)...format fill as needed
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi, welcome to the forum
1. highlight the range you want to apply the conditional formatting to
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =AND(D$3>=$B4,D$3<=$C4)...format fill as needed
Re: Conditionl Formating to highlight time slots between start and Finish time.
Thank you FDibbins! You're a champion
Last edited by excelrooky; 01-25-2017 at 02:35 AM.
happy to help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks