Results 1 to 9 of 9

change grid color

Threaded View

  1. #1
    Registered User
    Join Date
    06-24-2013
    Location
    Taipei
    MS-Off Ver
    MS365 Version 2310
    Posts
    16

    change grid color

    Hi,

    There are two Tables in my Excel sheet.
    one is control table and the other is presentation table.
    I would like to change presentation Table's grid color by control Table.
    (as attachment)

    It seems it cannot achieve by formula only, probably the VBA is necessary to use.
    Could anyone give me hint?
    Thank you!

    B.R.
    YU
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Color changing: change the color of one cell, and have other cells change colors too
    By hadydea in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-17-2019, 04:51 PM
  2. Add fill color grid to ribbon?
    By MetroBOS in forum Excel General
    Replies: 2
    Last Post: 05-19-2017, 09:42 AM
  3. Preserving grid lines when color filling?
    By Fernando12 in forum Excel General
    Replies: 2
    Last Post: 07-10-2007, 02:47 PM
  4. Replies: 2
    Last Post: 08-21-2006, 11:55 AM
  5. [SOLVED] No grid lines with color
    By BK in forum Excel General
    Replies: 2
    Last Post: 06-22-2006, 05:10 PM
  6. How do I change the orange color of the grid address highlight?
    By 140WWR068512232 in forum Excel General
    Replies: 3
    Last Post: 06-13-2005, 11:05 PM
  7. Be able to re-color INDIVIDUAL grid lines in excel charts
    By John Canino in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-15-2005, 01:06 AM

Tags for this Thread

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