+ Reply to Thread
Results 1 to 6 of 6

Help with making conditional formatting temporary

  1. #1
    Registered User
    Join Date
    09-28-2018
    Location
    El Salvador
    MS-Off Ver
    365
    Posts
    21

    Help with making conditional formatting temporary

    Hello everyone, I am trying to create a sheet with all of the employees schedules. Basically if on Monday employee 1 needs to be available, I would need the available cell to highlight green and so on. However, the function I have only applies to times of the day, but does not apply to the day of the week. For example, employee 2 has off on tuesday; therefore, the conditional formatting that applied on Monday, should not apply on tuesday for him. Any help on how I can make this work?

    Here I attach the sheet.
    Attached Files Attached Files

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

    Re: Help with making conditional formatting temporary

    Your example doesn't have any conditional formatting to correct.
    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.

  3. #3
    Registered User
    Join Date
    09-28-2018
    Location
    El Salvador
    MS-Off Ver
    365
    Posts
    21

    Re: Help with making conditional formatting temporary

    Thanks for the answer. The formula of the conditional formatting is this one =and(O19=O19,MOD(NOW(),1)>=O19,MOD(NOW(),1)<=P19)

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

    Re: Help with making conditional formatting temporary

    Try this...

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    09-28-2018
    Location
    El Salvador
    MS-Off Ver
    365
    Posts
    21

    Re: Help with making conditional formatting temporary

    I tried the formula, but it seems is not working. Do you think we may use the IF function together with the AND?? for example, IF today is Monday execute this "the conditional format"

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

    Re: Help with making conditional formatting temporary

    I'm still trying to understand what you want. Your description is vague and the formula you gave has no context.

    Can you provide and example workbook with your CF formulas? Even if the formulas don't work. It may help to provide a result worksheet with manually colored cells.

+ 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. [SOLVED] Making a planning template, need help with conditional formatting VBA
    By 323428 in forum Excel Programming / VBA / Macros
    Replies: 27
    Last Post: 04-04-2017, 03:31 PM
  2. [SOLVED] Conditional formatting making spreadsheet slow
    By carrod65 in forum Excel General
    Replies: 8
    Last Post: 02-22-2017, 05:02 PM
  3. Emulating conditional formatting in VBA, but making it permanent.
    By lankyfish in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-19-2013, 12:36 PM
  4. [SOLVED] Making code recognise conditional formatting
    By craigten in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-06-2013, 09:06 PM
  5. Making conditional formatting less tedious
    By Steve00 in forum Excel General
    Replies: 2
    Last Post: 06-21-2010, 02:43 PM
  6. making conditional formatting not continuous
    By zachg in forum Excel General
    Replies: 4
    Last Post: 12-05-2007, 03:50 PM
  7. [SOLVED] SQL - SELECT INTO making temporary Excel table
    By dave k in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-07-2005, 12:06 PM

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