Oct 15 2019 03:49 AM
Hi Community,
Is there any formula to find the cell colour value (RGB & Color Index Value) in Excel?
Following image shows my requirement.
Sample for Color Index Value (AutoCAD)
Oct 15 2019 05:40 AM
You may use the following User Defined Function to get the Color Index or RGB value of the cell color.
Place the following function on a Standard Module like Module1...
Function getColor(Rng As Range, ByVal ColorFormat As String) As Variant
Dim ColorValue As Variant
ColorValue = Cells(Rng.Row, Rng.Column).Interior.Color
Select Case LCase(ColorFormat)
Case "index"
getColor = Rng.Interior.ColorIndex
Case "rgb"
getColor = (ColorValue Mod 256) & ", " & ((ColorValue \ 256) Mod 256) & ", " & (ColorValue \ 65536)
Case Else
getColor = "Only use 'Index' or 'RGB' as second argument!"
End Select
End Function
And then assuming you want to check the color index or the RGB of the cell A2, try the UDF on the worksheet like below...
To get Color Index:
=getcolor(A2,"index")
To get RGB:
=getcolor(A2,"rgb")
Oct 15 2019 11:13 PM
Wow, it works well. Thank you so much for your support.
But, after trying out this UDF. I got a few questions popped up in my mind.
1. Noticed the duplicate colour index number.
2. The index & RGB value is not updated instantly after I change the cell colour.
3. And Is it possible to colour fill a cell using the RGB value?
Oct 13 2021 09:00 AM
Jul 19 2023 07:48 PM
Jul 21 2023 01:32 PM