rgb function

  1. F

    Background colour in RGB-scale matching with values.

    Hi all, I am working on a matrix consisting of multiple names matched to values. I would like to give everyone a specific RGB colour value (on different sheet). This way, one can easily recognize one another by colour (in addition to names and values in the cell). At this moment I have a...
    • FloFlo
    • Thread
    • colour formatting matrix rgb function rgb value vba & macros
    • Replies: 9
    • Forum: Excel Questions
  2. J

    Subscript out of range on RGB?

    I'm trying to set the interior color of a row, and for some reason I'm getting a "subscript out of range" error when I use the Interior.ColorIndex property. The goal is to mark Saturdays and Sundays in a chart. Code follows; any tips? If WorksheetFunction.Weekday(datWork, 1) = 1 Or...
  3. L

    VBA code to change object color based on value of another excel 2010

    Good morning, I am trying to create a heat map of the US that changes the shade of each state based on the values in another table range (B1:F45). There are 6 "tiers" of shade for each range of values: <colgroup><col><col></colgroup><tbody> 0 RGB(255,255,255) 1-140 RGB(235,241,222)...
  4. A

    RGB contrast COLOR Formula

    Need help to calculate the contrasting colors for given set of RGB values. For a <code> sub contrast() r=127 g=127 b=127 activecell.font.color=RGB(r,g,b) new_r=255-r new_g=255-g new_b=255-b activecell.interior.color=RGB(new_r,new_g,new_b) end sub </code> does not help when r,g,b values near...

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