Results 1 to 2 of 2

Conditional Formatting using Formulas as Formatting Criteria

Threaded View

AMON Conditional Formatting using... 09-13-2010, 11:23 AM
DonkeyOte Re: Conditional Formatting... 09-14-2010, 03:45 AM
  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

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