How To Get Color Index Number In Excel

[@jeremyfretts9797]

Thanks you so much! Is there also a way to force the cells to update if the color changes? Recalculate does not do it.

[@Excel10tutorial]

Use this code. If you edit any cell it will auto update the formula. Function GetColorIndex(VarRange As Range) As Integer Application.Volatile GetColorIndex = VarRange.Interior.ColorIndex End Function

[@metrix_x]

Target.Calculate Use that target.calculate to make other functions trigger the calc as well if needed

[@khuramwaqar418]

That was really quick and informative. Thanks

[@Excel10tutorial]

You're most welcome! Please subscribe and be with us.

[@monique36]

This was super helpful. Thank you!

[@Excel10tutorial]

You're most welcome! Please subscribe and share.

[@bjanediamante5757]

Thank you! It worked for me.

[@Excel10tutorial]

You're welcome! Please subscribe and be with us

[@DoIKnowU1]

hello there. its dery helpful. how can i do the opposit option?

[@MohAboAbdo]

Thank you so much.

[@Excel10tutorial]

You're welcome. Please subscribe and be in touch.

[@ClosedCircuit-yc5xn]

Thanks buddy

[@Excel10tutorial]

Happy to help

[@jamesmyrthong6112]

Thank You🙏🙏🙏👍👍👍

[@Excel10tutorial]

You're welcome. Please subscribe.

[@doti.k]

Thank you that was very helpful.

[@Excel10tutorial]

You're welcome!

[@argonaut119]

Hello: Would you know how to get the EXACT RGB value in Excel using VBA? I am trying to get the exact RGB values so that I can then use Fill Color with that specific RGB value in other cells. I have many cells with different colors in certain cells, columns or rows. Need to fill certain cells with specific colors based on the content of other cells. Some have conditional formatting and others do not. Tried to do this using ONLY Excel funtions (like CELL(...)) but Excel does not have a non-macro way of identifying the color ** (which I find just incredible that Excel could not provide a simple CELL('rgbvalue') to obtain the RGB value of a cell). What would be the simplest VBA code for this? I am now reviewing your VBA course to see how to better use VBA to support Excel requirements. Good job in teaching these topics. Thanks.

[@Excel10tutorial]

Thanks for subscribing. Here is your solution. The formula will be =GetRgbColor(A2) where A2 will be the cell reference. The code will be the following: Function GetRgbColor(Rng As Range) As String Dim ColorValue As Long ColorValue = Rng.Interior.Color GetRgbColor = (ColorValue Mod 256) & ", " & ((ColorValue \ 256) Mod 256) & ", " & (ColorValue \ 65536) End Function

[@vincentrose8889]

Is there a way to update the value if the cell colour updates

[@Excel10tutorial]

Try F9 and if it doesn't work let me know