Excel Fill schedule

Harrison Allen 20 Reputation points


Hi, I use a schedule sheet like the one in the photo. I would like it so when the times are input to the C column, the bars along the schedule are filled in automatically. Like the example in the photo

A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,619 questions
{count} votes

Accepted answer
  1. Barry Schwarz 2,271 Reputation points

    It will make life simpler if you change row 7 to the same format as column B. For example, in C7, replace "7-8" with "07:00-08:00".

    Then you can use a "common" conditional formatting formula for the bar cells. In C8, the formula would be AND(LEFT($B8,5)>=LEFT(C$7,5),RIGHT($B8,5)<=RIGHT(C$7,5)).

    You can copy this formula to all the bar cells. If you want different colors in the rows, you will need to adjust the action on a cell by cell basis.

0 additional answers

Sort by: Most helpful