+ Reply to Thread
Results 1 to 2 of 2

borders lines

  1. #1
    Registered User
    Join Date
    04-07-2013
    Location
    Penang, Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    1

    borders lines

    is it possible to count the cell border lines? in a rectangular cell there are 4 border. If I color red on 3 border lines, is there a formula to show its 3?

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,945

    Re: borders lines

    Hi, welcome to the forum

    Colors, fonts, borders etc are cosmetic formatting, not data. Excel formulas work on data, so there are no regular formulas that will do this for you - but perhaps somebody can put some VBA together to do this for you?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. Borders w/ lines at each page break
    By cmore in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-11-2014, 11:32 PM
  2. [SOLVED] Lines and borders are out of alignment with the cell contents
    By nltra in forum Excel General
    Replies: 0
    Last Post: 03-09-2006, 08:10 PM
  3. My borders show up as dashed lines. Why?
    By mannross in forum Excel General
    Replies: 1
    Last Post: 12-15-2005, 07:10 PM
  4. [SOLVED] Removing lines and/or borders
    By mystical_ways in forum Excel General
    Replies: 1
    Last Post: 08-09-2005, 03:05 PM
  5. HOW DO I ADD LINES AND BORDERS IN ASPREADSHEET
    By RUDY in forum Excel General
    Replies: 2
    Last Post: 03-02-2005, 08:06 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