+ Reply to Thread
Results 1 to 2 of 2

How to make the fill color of 2 column in separate sheets match

  1. #1
    Registered User
    Join Date
    03-08-2018
    Location
    IL
    MS-Off Ver
    2013
    Posts
    5

    How to make the fill color of 2 column in separate sheets match

    I need to make the fill color of one column match another, I have one column that lists equipment used in a user form sheet2! A1:A100. On my column on sheet 1 I have VBa set the fill color of column D of sheet 1 if it is broken turn red fixed turn green with an If then statement based off what “mode” my user form is in, report mode or fixed mode. Basically I want all my equipment listed on sheet 2 to stay fill green until it shows up on sheet 1 as fill red.

    I’ve tried using conditional formatting but haven’t gotten anywhere with it and anything I try in VBA won’t run.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,602

    Re: How to make the fill color of 2 column in separate sheets match

    (How to) Upload a Workbook directly to the Forum
    (please do not post pictures or links to worksheets)
    • Click Advanced next to Quick Post button at the bottom right of the editor box.
    • Scroll down until you see "Manage Attachments",
    • Click the "Choose" button at the upper left (upload from your computer).
    • Select your file, click "open", click "upload"
    • Once the upload is completed the file name will appear below the input boxes in this window.
    • Close the Attachment Manager window.
    • Click "Submit Reply"
    Note: Please do not attach password protected workbooks/worksheets
    Ensure to disable any Workbook Open/Autorun macros before attaching!
    Ben Van Johnson

+ 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. [SOLVED] Change a cells fill color. VBA to make another cell the same color and also changes.
    By PeteABC123 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-23-2016, 12:34 PM
  2. Replies: 2
    Last Post: 11-10-2015, 12:23 PM
  3. [SOLVED] Click oval option button to fill/unfill color, also change border color to match fill
    By Rocky2013 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-07-2015, 08:29 PM
  4. match column value and fill color in the row for the matched cells
    By jone kim in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-26-2014, 10:23 PM
  5. Match data on two sheets and pull identifer value from a separate column
    By kmrevolution in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-01-2014, 08:43 PM
  6. Fill Color for Duplicates Across all Sheets in Workbook in Column A
    By mikemorabito in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-24-2014, 01:26 PM
  7. 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

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