Results 1 to 3 of 3

Looking to match cell color along with cell values

Threaded View

  1. #1
    Registered User
    Join Date
    05-25-2016
    Location
    Hollywood, CA
    MS-Off Ver
    2016
    Posts
    79

    Looking to match cell color along with cell values

    Is there any way to format a cell's color to be the same as another cell that has a matching value? I can't see how it could be done with CF (which I'd rather stay away from anyway), so I'm wondering if anyone knows how this could be done - I've manually done this for cells C5:C7 on the Grid worksheet attached, for values that match C18:C25, but it would be nice to do it automatically, otherwise probably not worth the time... Any suggestions greatly appreciated!
    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. How to match the color of one cell to a cell on a different worksheet?
    By showboat in forum Excel Formulas & Functions
    Replies: 32
    Last Post: 10-23-2015, 10:16 AM
  2. Replies: 8
    Last Post: 06-27-2015, 03:21 PM
  3. Macro to make the background color of a cell match that of another cell
    By LukeWarmwater in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-04-2014, 06:11 AM
  4. How to use color Index VBA to match cell color in first tab to the second tab
    By susanliu in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-29-2014, 06:55 PM
  5. Match Cell Fill Color to another cell in same column in Array?
    By Trevorrow in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-19-2013, 10:06 AM
  6. Replies: 12
    Last Post: 09-18-2012, 03:13 PM
  7. [SOLVED] Cell fill color. Row to match specific cell.
    By CADinDallas in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-04-2006, 09:10 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