+ Reply to Thread
Results 1 to 4 of 4

Conditional Formatting on a sheet with many rules

Hybrid View

  1. #1
    Registered User
    Join Date
    05-22-2013
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2010
    Posts
    12

    Conditional Formatting on a sheet with many rules

    Dear All,

    I have a sheet where there are 3 rules applied using conditional formatting based on the below:

    1) Next Week
    2) Tomorrow
    3) This Week
    4) Today

    When the date selected is supposed to be in this week and tomorrow, how do i make the 'Tomorrow' rule apply first?
    For my sheet, the 'This Week' rule seems to be overriding the other rules.

    I have tried using the 'Stop If True', but how do i apply it to make it work?

    Thanks!

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Conditional Formatting on a sheet with many rules

    in the CF window, move that rule to the top (click it, then click the up arrow). Then check the "stop if true" box
    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

  3. #3
    Registered User
    Join Date
    05-22-2013
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2010
    Posts
    12

    Re: Conditional Formatting on a sheet with many rules

    Thanks so much!

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Conditional Formatting on a sheet with many rules

    Happy to help

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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