+ Reply to Thread
Results 1 to 2 of 2

Shading cells once info on a column changes

  1. #1
    Registered User
    Join Date
    02-06-2013
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Shading cells once info on a column changes

    Good afternoon,

    My initial problem was alternating the shade of cells once there is a change in value based on information on 1 column.

    Fortouantely I have a formula that can do this when i use conditional formating; however, I am at a loss on how it works. Below is the formula

    =MOD(SUMPRODUCT(--(($A$1:INDIRECT(ADDRESS(ROW()-1,1,3,1))=$A$2:INDIRECT(ADDRESS(ROW(),1,3,1)))=FALSE)),2)

    Question:

    How does it work?

    In particular, in the sumproduct function, there are two "-". Additionally, why is it assigning a false value? What does this code do: (--(($A$1:INDIRECT(ADDRESS(ROW()-1,1,3,1))=$A$2:INDIRECT(ADDRESS(ROW(),1,3,1)))=FALSE)?

  2. #2
    Registered User
    Join Date
    02-06-2013
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Shading cells once info on a column changes

    bump..........

+ 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