Results 1 to 3 of 3

Format Cell Color if Difference Found

Threaded View

  1. #1
    Registered User
    Join Date
    11-21-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    33

    Format Cell Color if Difference Found

    I have a macro that takes data from two different sheets (current year, previous year) and calculates (subtracts) the difference in values. These are grouped by the values in column A. If the values do not equal 0, meaning no difference between the two datasets, i want the cells highlighted red. In the example I've attached, I've highlighted the rows to display the way the data is grouped for comparison. I do not wish for these to be highlighted from the macro, only the cells in the rows that display the difference in value (not 0) is shown. This cell formatting should occur in every third row as this is the row where the calculations occur. Also, I need to clarify that my beginning cell is B8 which is column headings and B9 contains first value NOT A1 & A2 provided in the image example.


    Compare Values and Format Cell Color Where Difference Found.JPG
    Last edited by Huskersippi; 02-21-2019 at 11:30 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Change cell format (cell color+font color) based on color of another cell
    By Dedaluss in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-30-2017, 03:27 AM
  2. Chage Color in one cell based on the difference in days from another cell
    By Arnebjarne in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-11-2015, 07:58 AM
  3. Change a Range's cell background color to that of another cell's cond. format color
    By kamelkid2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-31-2014, 12:57 PM
  4. Change cell background color according to value found in a table
    By gelk in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-11-2014, 10:43 AM
  5. [SOLVED] Color-format a cell which contains data in a column based on the color of another cell
    By Nit3hawK in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-27-2013, 05:25 PM
  6. Replies: 0
    Last Post: 09-26-2012, 01:08 PM
  7. identify found cell by changing color
    By ClearConcept in forum Excel General
    Replies: 2
    Last Post: 10-30-2009, 03:26 PM

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