+ Reply to Thread
Results 1 to 2 of 2

Copying a Conditional Format Rule from One Row to Many Rows

  1. #1
    Registered User
    Join Date
    04-08-2011
    Location
    Tulsa, Oklahoma USA
    MS-Off Ver
    Excel 2007
    Posts
    9

    Copying a Conditional Format Rule from One Row to Many Rows

    Hello Excel Masters! You have not failed me yet! I have a tough one here:

    I have a range of data in a single sheet, from A3 to T500. I have set a conditional format rule, using a formula, in cell T3, such that, if $T$3="C", then the entire row of $A$3:$T$3 is colored light green. It works great.

    Now, I want to establish this same conditional format rule for every row 3 through 500. I want to "copy" the conditional format rule I made in T3 on down to the last row of my data. Is this possible, or do I need to manually add a conditional format rule to each row at column T?

    Thanks for the help!!

    Chris From Tulsa, OK

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Copying a Conditional Format Rule from One Row to Many Rows

    Hard to picture the data when I can't visualize it. But if you want to apply conditional formatting every other 3 row, you can use formula like

    IF(Mod(Row(),3 = 3, True, False)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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