Results 1 to 14 of 14

Color rows based on Value above

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    3,977

    Color rows based on Value above

    I'm sorry; I'm down with some type of sinus sickness, so my brain isn't working right, otherwise I'm sure I could figure this out. I want to color each row in my spreadsheet if the value in column C matches the value of column C above or below it. I know how to color the rows, but I'm drawing a blank on how I'd set up the
    IF A1=A2
    'Run my code
    
    On both A1 and A2
    We're talking about 14000 lines, and in that range there are 6000 unique values.

    Thanks in advance for any help on this.
    Last edited by jomili; 11-23-2011 at 11:32 AM.

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