+ Reply to Thread
Results 1 to 5 of 5

Conditional border formatting formula (after repeat 5 data)

  1. #1
    Forum Contributor
    Join Date
    01-22-2013
    Location
    Pekanbaru, Indonesia
    MS-Off Ver
    Excel 2013 & Google Sheet
    Posts
    1,146

    Conditional border formatting formula (after repeat 5 data)

    hello all,

    how to make conditional formatting for border line (top & bottom) after repeat 5 data/text ....

    it's possible with CF formula and do not vba?

    please, see my excel file attached..

    any help, must be appreciated...

    john m
    Attached Files Attached Files

  2. #2
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Conditional border formatting formula (after repeat 5 data)

    Hi John, It is almost as you wanted
    Attached Files Attached Files
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  3. #3
    Forum Contributor
    Join Date
    01-22-2013
    Location
    Pekanbaru, Indonesia
    MS-Off Ver
    Excel 2013 & Google Sheet
    Posts
    1,146

    Re: Conditional border formatting formula (after repeat 5 data)

    alkey, it's exactly for me....

    EXCELLENT !!!!!

    Thanks you very much.........

  4. #4
    Registered User
    Join Date
    07-18-2013
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    88

    Re: Conditional border formatting formula (after repeat 5 data)

    Quote Originally Posted by AlKey View Post
    Hi John, It is almost as you wanted
    I tried doing it a different way as per his request, COUNTA above cell and then an ISBLANK but was struggling to leave the blank gap in between the data.

  5. #5
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Conditional border formatting formula (after repeat 5 data)

    You're welcome and thank you for the feedback!

    Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).

+ 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. [SOLVED] Conditional formatting formula (around border) & skip blank cell
    By Jhon Mustofa in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-07-2014, 07:02 PM
  2. Conditional formatting border formula
    By Jhon Mustofa in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-17-2014, 03:25 AM
  3. [SOLVED] Need help : Conditional formatting border line with skip blank data
    By Jhon Mustofa in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-30-2013, 11:27 AM
  4. Replies: 2
    Last Post: 10-09-2012, 03:57 PM
  5. Border-/Frameless Data Bars (Conditional Formatting)?
    By Scruff.R in forum Excel General
    Replies: 2
    Last Post: 08-13-2012, 03:02 AM

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