Results 1 to 4 of 4

Creating Schedule with Conditional Formatting

Threaded View

  1. #1
    Registered User
    Join Date
    02-07-2023
    Location
    McAllen, TX
    MS-Off Ver
    Mac Excel 16.70
    Posts
    2

    Post Creating Schedule with Conditional Formatting

    I am trying to create a schedule template to use at my store. I have added conditional formatting to the Barista part of the schedule. We have three different shifts to cover (open, mid & close). I added rules to color code each when a "time in" has been chosen. What I am having issues with is the closing shifts because they vary for time in. Example on Saturdays a mid can be 3pm-8pm but another barista can have 3pm-10pm which is closing but since the rule is already selected to be blue for 3pm, it does not apply the closing rule. I am not sure what else I can do to help me resolve this issue.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 6
    Last Post: 02-15-2018, 11:54 PM
  2. [SOLVED] Conditional Formatting a Schedule
    By Rob Hick in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2005, 07:05 AM
  3. Conditional Formatting a Schedule
    By Rob Hick in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 04:05 AM
  4. Conditional Formatting a Schedule
    By Bob Wall in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  5. [SOLVED] Conditional Formatting a Schedule
    By Bob Wall in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  6. [SOLVED] Conditional Formatting a Schedule
    By Bob Wall in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  7. Conditional Formatting a Schedule
    By Bob Wall in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1