Get code of color in cell

[Ssaamirr]

Hello, I have some values in cell which are colored with different colors. I want to compare values which are colored. Now the easiest way it's to have code of color which is unique for each shade of some color (I guess), so how could I get that code/number of color.

example: if A1 is blue then in B1 type digital number of that color and so on..

[Richard Buttrey]

Hi,

Personally I don't think using colour code values is robust enough. Better to use whatever is driving the cell colours. If it's conditional formatting then use the CF conditions in any comparisons.

[Ssaamirr]

I can't use CF for that operation..

[Richard Buttrey]

Hi,

I didn't say you should. I was merely trying to establish what process you were using to paint the cell colours. That's why I used the phrase 'If it's CF...'

[sktneer]

To get the color index, you may try this piece of code........

Please Login or Register  to view this content.

[Ssaamirr]

Great! That's what I need Tnx

[Ssaamirr]

Hmm, I found some mistakes, try different shades of grey, for 2 different shades show the same number.. also for purple..

[Richard Buttrey]

Hmm, I found some mistakes, try different shades of grey, for 2 different shades show the same number.. also for purple..

...exactly as I warned in post #2.

If the cells are permanently coloured then I suggest you use a helper column which contains a code you devise that uniquely identifies the colour and use that in your code. OTOH if they are conditional formats then as I intimated, use the same logic as you use in the CF.

[Ssaamirr]

Hmm.. I don't understand you completely, what do you mean by helper column?