+ Reply to Thread
Results 1 to 4 of 4

Conditional Formatting

  1. #1
    Registered User
    Join Date
    08-26-2014
    Location
    New York
    MS-Off Ver
    Excel:mac 2011
    Posts
    2

    Angry Conditional Formatting

    I have tried to figure this out myself but I have had no luck. It seems simply enough, but perhaps not.

    Here is what I'm trying to do.

    If A1 = Today then I want a "1" in A2
    If A1 = This week then I want a "0" in A2
    If A1 = Any date other than today or this week then I want a "2" in A2

    Thank you all in advance for the help.

    Sincerely,

    Shannon

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,877

    Re: Conditional Formatting

    Hi Shannon and welcome to the forum,

    See if the attached gives you the formula you are looking for.
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Rocester, New York, USA
    MS-Off Ver
    Excel 2007:10
    Posts
    2,019

    Re: Conditional Formatting

    This isn't conditional formatting, it's just a regular logic expression.

    At any rate, put this in cell A2:
    Please Login or Register  to view this content.
    Note this is "week starting on Sundays"; I assumed that's what you want 'cause it's kind of the default, but if it isn't, change the second term on those WEEKNUM expressions appropriately.

    I also wrapped a year-check in with the "which week" check so that, for example, if it's the same week in a different year, that will also throw it out.

  4. #4
    Registered User
    Join Date
    08-26-2014
    Location
    New York
    MS-Off Ver
    Excel:mac 2011
    Posts
    2

    Re: Conditional Formatting

    MarvinP,

    Thanks for your help. Please see the attached. What am I doing wrong? Test.xls

    The value will not appear once I have entered the formula. Perhaps my brain is fried.

    Thanks again.

    Shannon

+ 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. Formatting Cells with Date or Text Values in a Conditional Formatting Formula
    By Phil Hageman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-15-2014, 09:36 AM
  2. Opening xlsm files with conditional formatting opens with removed conditional formatting
    By Martijn.Steenbakker in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-07-2014, 05:38 AM
  3. Replies: 1
    Last Post: 09-20-2013, 06:23 PM
  4. 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
  5. Replies: 3
    Last Post: 05-15-2012, 04:13 PM

Tags for this Thread

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