+ Reply to Thread
Results 1 to 2 of 2

Assistance with linked cells: bold formatting & filled cells

  1. #1
    Registered User
    Join Date
    06-18-2011
    Location
    Michigan
    MS-Off Ver
    Excel 2007
    Posts
    5

    Question Assistance with linked cells: bold formatting & filled cells

    Hello,

    Please see my attachment, which is a sample of my worksheet.

    1) I would like each row of five cells in a group of cells to be formatted bold if the number in the first column is 1. (Please see the first group of cells called "Sector A" as an example of how I would like it to format automatically.)

    2) I would also like any blank cells to automatically fill, preferably with the pattern/color (thin horizontal crosshatch) also shown in the "Sector A" group of cells.

    3) Next; when I link any of the groups of cells from the worksheet to a group of cells on sheet2 (sheet2 is formatted in a smaller font, if that is relevant,) I would like the cells with auto bold formatting and auto fill from the worksheet to carry it to sheet2.

    4) Lastly; all of the blank (soon to be auto filled?) cells from the worksheet automatically have a value of 0, 0.00, 0.0% on sheet2 when they are linked. I need those cells to be linked so that I can add information later, but I don't want the 0's in the cells. *I just found this answer in the thread titled "=c5 how to prevent blank cells from being represented as "0"? " and answered by Jeff. Thank you!

    I would be very grateful for any assistance. Thank you for you help!

    Beth
    Attached Files Attached Files
    Last edited by chiasmus811; 06-25-2011 at 01:49 AM. Reason: Attaching sample spreadsheet / found answer to #4 on a different thread

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: Assistance with linked cells: bold formatting & filled cells

    Beth,

    Using your sample file this is actually quite tricky to do with a universal approach, however, the below should resolve 1 & 2:

    Highlight A3:Q23 and apply the following Conditional Format rules:

    Please Login or Register  to view this content.
    Note Rule2 assumes that you always have 2 "empty" lines in each table following last record (per sample file).

    Regards Q3 - I don't really follow - there's only one sheet in your sample for ex. I would suggest posting a revised example (with above in place) such that people can see what you're trying to achieve - in other words include your desired results (before & after type approach).

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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