+ Reply to Thread
Results 1 to 5 of 5

Conditional formatting, three conditions

  1. #1
    Registered User
    Join Date
    02-26-2014
    Location
    chicago
    MS-Off Ver
    Excel 2003
    Posts
    5

    Conditional formatting, three conditions

    Hi all. I've searched some conditional formatting topics on here, but I still can't seem to get my formula to work. I have a data set where each row is a person, and each column is the number of logins they've made to a site during a weekly period. I'm attempting to highlight the week in which any given user stops using the website. The formula I'm trying is:

    =AND(NOT(L2=0),N2=0,M2=0)

    Where column L is week 1, column N is week 2, and so forth. This is the formatting for the cells in column M. I'd like it so that if L is greater than 0, M is equal to 0, and N is equal to zero, then the cell in column M is highlighted red. Excel seems to accept the formula, but some cells are getting highlighted which aren't actually meeting the conditions...

    Any thoughts?

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,727

    Re: Conditional formatting, three conditions

    your formula is showing row 2
    and if you are applying to the column N then you will be one row out - so if you are applying to column M then change the row to 1
    =AND(NOT(L1=0),N1=0,M1=0)

    also
    =AND(L1>0,N1=0,M1=0)
    will also work
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Registered User
    Join Date
    02-26-2014
    Location
    chicago
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Conditional formatting, three conditions

    Wow.... can't believe it was that simple of a change. Thanks!

  4. #4
    Forum Contributor
    Join Date
    12-09-2013
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    171

    Re: Conditional formatting, three conditions

    Try

    = And(L1>0,N1=0, M1=0)
    Like my answer, then click * below

  5. #5
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,727

    Re: Conditional formatting, three conditions

    your welcome, catches me out a few times too

    if my assistance has helped, and only if you wish to , there is a reputation icon * on the left hand side - you can add to my reputation here

+ 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. Delete Conditional Formatting conditions but keep cell formatting - Excel 2010
    By tetreama in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-09-2012, 08:28 PM
  2. How to add more conditional formatting conditions than 3?
    By Smirgelius in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 03-22-2009, 03:59 AM
  3. Need 6 Conditions / Conditional Formatting
    By Rothman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-14-2006, 06:10 PM
  4. Conditional formatting wth more than 3 conditions
    By Sue in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  5. [SOLVED] Conditional formatting wth more than 3 conditions
    By Sue in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM

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