+ Reply to Thread
Results 1 to 2 of 2

If Then statement using the background color

  1. #1
    Registered User
    Join Date
    09-22-2018
    Location
    Colorado Springs, CO
    MS-Off Ver
    7
    Posts
    1

    If Then statement using the background color

    Hello, I am trying to use an If Then statement to compare two spreadsheets for content. If the two spreadsheets had the same information, then that row was green. If the one spreadsheet had information that the other one didn't then the row is yellow. Then I would like to summarize all of the yellow data at the bottom of the spreadsheet to know what data I needed to add so that both spreadsheets contained the same data. So far, I have added the CellColor to the Cell Manager but can't figure out the if then statement. Thanks in advance for any help.

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    Hello Proprius,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ 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. Replies: 8
    Last Post: 04-02-2016, 04:00 AM
  2. Change cell background color based on another cells background color
    By Queo in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 06-10-2014, 05:28 AM
  3. Replies: 4
    Last Post: 12-29-2013, 11:41 PM
  4. Can an IF statement determine the background color of a cell?
    By MDOC in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-25-2013, 04:28 PM
  5. Replies: 6
    Last Post: 11-07-2012, 10:46 AM
  6. [SOLVED] Macro to change all cells with a certain background color in another background color
    By kevinvzandvoort in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-13-2012, 11:04 AM
  7. Change background color with IF statement
    By DarrenMPY in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-26-2006, 04:58 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1