Detect the color of cells in a column within a table VBA?

[Klash Ville]

Hello everyone, I would like to ask your assistance on a problem.

I have column1 and column2 with the total of 20 cells each.

I need a dynamic code in VBA that would calculate all blue cells in column1 * all blue cells in column because the order may not be the same. Also, how do I even detect the color in excel into VBA?

Any sugestions?

 

[RedBeard]

Here's a good thread on the subject, check out Rick Rothstein's reply:

https://answers.microsoft.com/en-us...d/cbc59a54-4b6b-43e4-9218-ae5db59255aa?auth=1

Here's another good example: https://stackoverflow.com/questions...lled-with-any-color-and-highlighting-correspo