Excel - Get color code

February 2017





You can make use of this macro to get the color code:

Sub distri_color()  
Dim i
For i = 1 To 12
Worksheets(1).Range("C" & i).Value = Worksheets(1).Range("B" & i).Interior.Color
Next i
End Sub
  • 'Replace 12 by the number of rows you want to use.
  • 'Replacing the I in the column that you want to use for the result (color code).
  • 'Replace the B by the column containing the color you want to filter.

Related


Published by jak58. Latest update on November 2, 2016 at 06:12 AM by owilson.
This document, titled "Excel - Get color code," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).