+ Reply to Thread
Results 1 to 2 of 2

Conditional Formatting using Formulas as Formatting Criteria

  1. #1
    Registered User
    Join Date
    09-13-2010
    Location
    West Bloomfield, MI
    MS-Off Ver
    Excel 2010
    Posts
    2

    Conditional Formatting using Formulas as Formatting Criteria

    I have a report titled, "Daily Sales Tracker", that has a separare tab for every day of the month. I have created an additional tab titled, "Reps" which pulls info from every daily tab to indicate if a rep worked or not. The info puuled is as follows:
    1=Rep Worked
    0=Rep Was Off
    X or blank=Rep Did Not Report
    We need to know when a rep has not worked for 3 consecutive days (0, X, or blank). I am attempting to use conditional formatting to fill those cells that meet that criteria, but have been having trouble doing do. I tried using the following formula:
    =NOT(OR(C6=1,D6=1,E6=1))
    and applying to to the following area:
    =$C$6:$AB$57
    but it's not working.

    Does anyone have any suggestions on how to get this working?
    Thanks!
    Attached Files Attached Files

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Conditional Formatting using Formulas as Formatting Criteria

    It's generally a good idea to provide an "after" view so we can see what the end result "should" look like... it's not very clear.

    If the intention is to highlight any days where at that point fewer than 3 consecutive days have been worked then in terms of a possible CF rule:

    Please Login or Register  to view this content.
    The IFs are just used to ensure only nec. calcs are performed

    (If you have a row starting with 1,1 neither would be highlighted as we don't know the run at the end of the prior month)

+ 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