Results 1 to 9 of 9

Macro to compare colors in cell and type result

Threaded View

Ssaamirr Macro to compare colors in... 02-06-2014, 07:47 PM
AlphaFrog Re: Macro to compare colors... 02-06-2014, 11:40 PM
Ssaamirr Re: Macro to compare colors... 02-07-2014, 12:29 PM
Ssaamirr Re: Macro to compare colors... 02-10-2014, 03:49 AM
AlphaFrog Re: Macro to compare colors... 02-10-2014, 10:50 PM
Ssaamirr Re: Macro to compare colors... 02-11-2014, 09:38 AM
Ssaamirr Re: Macro to compare colors... 04-24-2014, 12:07 PM
AlphaFrog Re: Macro to compare colors... 04-25-2014, 09:46 AM
Ssaamirr Re: Macro to compare colors... 06-17-2014, 06:13 AM
  1. #1
    Registered User
    Join Date
    11-26-2013
    Location
    Ljubljana, Slovenia
    MS-Off Ver
    Excel 2003
    Posts
    43

    Macro to compare colors in cell and type result

    Hello sorry for bad english,

    like u see in attachment i have products in cells wich are painted in different colors. I need to compare two numbers of different product, and write result to column "Type D,C,B". If one of two products is without color/white or they are not the same color then result is always "D", if both products/cells have same color and different number then results is "C", if the color and number is the same then result is "B"

    Below cell B2 I will write numbers by hand, when I finish and start macro it will compare first cell B2 and B3 and write result to C3, then compare B3 and B4 and write result to C4 and do that until there is any number in column B:B.

    Hope u can help me . :)

    Tnx
    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. Change all colors of a type with one code
    By rybussell in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-22-2014, 02:32 AM
  2. Macro to subrtract two ranges and compare the result with condition
    By naga in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-02-2013, 11:03 AM
  3. Replies: 6
    Last Post: 08-06-2012, 03:09 PM
  4. compare 2 worksheets & transfer cell colors
    By LeeHa in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-01-2008, 08:54 AM
  5. [SOLVED] Compare cell = one result
    By Aaron Saulisberry in forum Excel General
    Replies: 7
    Last Post: 01-23-2006, 12:55 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