+ Reply to Thread
Results 1 to 3 of 3

Format Cell Color if Difference Found

  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.

  2. #2
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: Format Cell Color if Difference Found

    Select B4 and set ConditionalFormattting with the equation =AND($A3="", B3<>B2)

    Copy that CF to the other cells you want to have this feature.
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

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

    Re: Format Cell Color if Difference Found

    TY for the reply.... This is not suitable as there are 1000 rows in the actual spreadsheet .... and can vary from month to month. I need a macro that will accomplish this formatting.
    Last edited by Huskersippi; 02-21-2019 at 12:08 PM.

+ 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. 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