+ Reply to Thread
Results 1 to 2 of 2

Conditional Formatting Rules for an Appointment Scheduler

  1. #1
    Registered User
    Join Date
    03-10-2017
    Location
    LONG BEACH, ca
    MS-Off Ver
    MS OFFICE 2013
    Posts
    2

    Question Conditional Formatting Rules for an Appointment Scheduler

    I am working with Excel 2013 and successfully created a schedule for one month for our nurse practitioner to use to block their time efficiently when providing medical treatment for our clients. Some treatment may take 15 minutes others up to 45 minutes. In creating this schedule I successfully have the conditional formatting rule filling 3 rows (=45 minutes), however it's filling the 2 slot above or earlier than the selected appointment time.

    Attachment 563977

    The date is in Column A and time in Column B. The information I'm searching for is the word "RPR" in Column H. The conditional formatting would be in B2:K226. Here is what the Conditional Formatting Rule looks like:

    =SEARCH("RPR",$H1) Applied to =$B:$K
    =SEARCH("RPR",$H2) Applied to =$B:$K
    =SEARCH("RPR",$H3) Applied to =$B:$K

    It does that I was looking to do, however, in the wrong direction. Could anyone provide some feedback on how to rewrite the formula or use other conditional formatting formulas that could do this? It seems like a simple fix, but I've racked my brain long enough. I can send the link if anyone would like to look at it.

    Thank you!
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Conditional Formatting Rules for an Appointment Scheduler

    In row 2, use this one condition.
    =SEARCH("RPR",$H2)

    In row 3, use this...
    =SEARCH("RPR",$H2 & $H3)

    In Row 4 on down, use this...
    =SEARCH("RPR",$H2 & $H3 & $H4)

    You'll have to adjust the conditions for each break and day change.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Appointment Scheduler - tracking visits across worksheets
    By kdelacr2 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-30-2016, 10:26 PM
  2. HELP/RUSH: Excel Appointment Scheduler
    By alunacix in forum Excel General
    Replies: 1
    Last Post: 04-25-2014, 10:01 PM
  3. conditional formatting rules for a cell on sheet 1 based on rules from sheet 2
    By jsard in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 08-15-2013, 09:22 AM
  4. Conditional Formatting for appointment scheduling.
    By Mr. H2 in forum Excel General
    Replies: 0
    Last Post: 04-09-2013, 09:50 AM
  5. [SOLVED] Conditional Formatting for appointment spreadsheet
    By bsspsyd in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-13-2012, 01:09 PM
  6. Appointment Scheduler - multiple
    By calebm12 in forum Excel General
    Replies: 2
    Last Post: 03-25-2008, 02:28 PM
  7. Scheduler and Conditional Formatting
    By spacemonkey in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-13-2006, 05:13 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