+ Reply to Thread
Results 1 to 4 of 4

Conditional Formatting stops working after adding column

  1. #1
    Forum Contributor
    Join Date
    08-15-2006
    Location
    USA
    MS-Off Ver
    Office 365, 64 bit
    Posts
    362

    Conditional Formatting stops working after adding column

    I have a conditional formula that highlights dates red when it meets a certain criteria. The file named MS Working, the conditional formatting formula (formula below) works as it should with no issues. The other file MS NOT Working, the conditional formatting formula (formula below) has stopped working as it should. What I did? I inserted a new column to the left. Where the MS Working file has only 1 column to the far left, the MS NOT Working file now has 2 columns to the far left.

    It seems as if the formula adjusted itself when I inserted the new column; however, its not working. I've tried everything to the best of my knowledge to figure this out. What can I do to fix it?

    MS Working
    Conditional Formula: =AND(TODAY()>B3,NOT(ISODD(COLUMN())),B3<>"",OR(C3="",C3=0),B3<>0)

    MS NOT Working
    Conditional Formula: =AND(TODAY()>C3,NOT(ISODD(COLUMN())),C3<>"",OR(D3="",D3=0),C3<>0)
    Attached Files Attached Files
    Last edited by rz6657; 05-21-2013 at 06:57 PM.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,612

    Re: Conditional Formatting stops working after adding column

    Previously you tested for EVEN columns; however, adding a column moved verything to ODD:
    =AND(TODAY()>B3,ISODD(COLUMN()),B3<>"",OR(C3="",C3=0),B3<>0)
    Ben Van Johnson

  3. #3
    Forum Contributor
    Join Date
    08-15-2006
    Location
    USA
    MS-Off Ver
    Office 365, 64 bit
    Posts
    362

    Re: Conditional Formatting stops working after adding column

    What do I use instead?

  4. #4
    Forum Contributor
    Join Date
    08-15-2006
    Location
    USA
    MS-Off Ver
    Office 365, 64 bit
    Posts
    362

    Re: Conditional Formatting stops working after adding column

    Ok, I got it. I changed it to ISEVEN and wow, it works... thanks a lot protonLeah!!

+ 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