+ Reply to Thread
Results 1 to 3 of 3

Conditional formatting formula (around border) & skip blank cell

  1. 04-07-2014, 11:17 AM #1
    Jhon Mustofa
    Jhon Mustofa is offline
    Forum Contributor
    Join Date
    01-22-2013
    Location
    Pekanbaru, Indonesia
    MS-Off Ver
    Excel 2013 & Google Sheet
    Posts
    1,146

    Conditional formatting formula (around border) & skip blank cell

    hi all,

    i need conditional formatting formula to make border line around with skip blank cell/empty...

    please, see my workbook attached...


    any help will be great appreciated....

    john m

    cheers....
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-07-2014, 06:27 PM #2
    aydeegee
    aydeegee is offline
    Valued Forum Contributor
    Join Date
    09-25-2011
    Location
    Eastbourne, England
    MS-Off Ver
    Excel 2010
    Posts
    1,089

    Re: Conditional formatting formula (around border) & skip blank cell

    Hi John

    I convinced myself that it could not be done with CF, so I wrote a macro to do it.

    I then found a much easier way of doing it with CF !

    I attach both.

    Let me know if you have any queries

    Regards
    Alastair
    Attached Files Attached Files
    Last edited by aydeegee; 04-07-2014 at 06:29 PM.
    Reply With QuoteRegister To Reply
  3. 04-07-2014, 07:02 PM #3
    Jhon Mustofa
    Jhon Mustofa is offline
    Forum Contributor
    Join Date
    01-22-2013
    Location
    Pekanbaru, Indonesia
    MS-Off Ver
    Excel 2013 & Google Sheet
    Posts
    1,146

    Re: Conditional formatting formula (around border) & skip blank cell

    Hi, Alastair, thank you very much.....
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Conditional formatting border formula
    By Jhon Mustofa in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-17-2014, 03:25 AM
  2. [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
  3. Conditional formatting - If cell contains text then insert border for that row - multiple
    By Calamity in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-25-2013, 04:41 AM
  4. Conditional Formatting to mirror another Cell by Border Outline
    By Alayer in forum Excel General
    Replies: 5
    Last Post: 12-09-2011, 07:32 PM
  5. One criteria AND cell is blank in conditional formatting formula?
    By westis in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-19-2008, 06:37 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1