I have created a macro to color-coordinate sales transactions based on different criteria. The range is columns F:R, with an unknown number of transactions. I have been using AutoFilter to conditionally format the data.

It first colors the entire row based on transaction Type (sale, void, authorization), and then colors the entire row based on the Response (approved, declined, etc). The last step is to color the actual Card Type (column I) for each of the corresponding transactions. I wanted the AMEX cells to be light teal, and the remaining card type (Discover, MC, and Visa) cells to be pink.

When it colors the AMEX cells teal, it works perfectly. When it moves on to color the remaining card types, which should ALL be pink, I first see a flash of pink, and then they all become DARK TEAL. I have gone through my code repeatedly and cannot figure out why the cells for Discover, MC and Visa are flashing pink for a second, and when the macro has finished running, all the Discover, MC and Visa cells are dark teal. The color code/RGB code for the dark teal color is nowhere in the code... If someone could PLEASE help me, that would be incredible! I am truly stumped!

NOTE: I hope my code isn't too messy. (For example, my named ranges got a little out of hand on this macro.) This is the first time I have posted a VBA question to a forum (or shown anyone my codes, for that matter). If you have any VBA advice, I would love to improve!!

Please Login or Register  to view this content.