+ Reply to Thread
Results 1 to 2 of 2

Put Borders Every 2 Rows Base on Filtered Results

  1. #1
    Registered User
    Join Date
    03-18-2014
    Location
    Manila, Philippines
    MS-Off Ver
    Excel 2007
    Posts
    9

    Put Borders Every 2 Rows Base on Filtered Results

    Hello,

    I have an Excel worksheet "DAILY." I put a Macro for this sheet that for every worksheet change of Cell B3. It will only filter the results where ISSUED column is greater than zero. Now what I want to do is that base on this filtered results, there will be a border every 2 rows.

    I tried to use Conditional Formatting but this will affect the whole range.

    Do you have any ideas on how to make this work? I have attached the sample Excel 2007 file.

    Any help will greatly be appreciated. Thank you!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,937

    Re: Put Borders Every 2 Rows Base on Filtered Results

    Select A5:G949 and use CF formula

    =MOD(SUBTOTAL(103,$A$5:$A5),2)=0 with bottom border, and
    =MOD(SUBTOTAL(103,$A$5:$A5),2)=1 with upper border.

    Shown in the attached.

    sample.xlsm
    Bernie Deitrick
    Excel MVP 2000-2010

+ 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. Replies: 4
    Last Post: 08-16-2012, 06:20 PM
  2. Using VBA to autofilter and paste over results - can't select only filtered rows.
    By Cornwell in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-14-2010, 11:33 AM
  3. SUM of filtered results
    By bealy in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 02-25-2009, 12:33 AM
  4. SUM of filtered results?
    By Ascesis in forum Excel General
    Replies: 4
    Last Post: 07-26-2006, 01:30 PM
  5. [SOLVED] Strange Log base 10 results
    By Chip Hankley in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-04-2005, 11:06 PM

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