xlrgbcolor

  1. Rhodie72

    Change cell interior color according to the xlrgbcolor name in cell

    I'm stuck here. Can anyone please show me how to use the rgb name in a cell to make the cell adjacent to it change color? Here's what I've got so far: Sub SetColour() Dim Colour As String, rgbColour() As XlRgbColor, n As Long For n = 1 To Range("A1").CurrentRegion.Cells.Count Colour...
  2. Rhodie72

    How to fill cells with color from Excel.xlrgbColor.<name> specified in worksheet

    Background info: I am trying to fill out a worksheet with a colour range from VBA named colours. The idea is to place the name of the colour in the cell and cell.offset(0,1).Interior.color=xlrgbColor. Here is a table of color names from the Excel.xlrgbColor.<1 to 143> range Assume start...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top