interior.color

  1. Scott Huish

    VBA - Interior Color to HTML RGB Hex Code

    Hi, I need to be able to convert the number that Interior.Color returns to an RGB Hex Code like #005473 or #FF00EE , etc. Any ideas? Thanks.
  2. K

    display message box when cell color is red

    I have a cell with conditional formatting to turn red when a certain condition is met. is there a VBA code that will display a message box stating duplicate based on a cell color? so what I need is when a cell turns red, a message box to appear showing duplicate. here is the code I have but it...
  3. C

    How to get the Interior.Color value in one cell to change the Interior.color value of a different cell

    I am writing code to have multiple worksheets update a master worksheet and need to find a way to have the Interior.Color value in cells in one spreadsheet cause the corresponding cell in a different spreadsheet have the same Interior.color. here is the code I have so far: Option Explicit Dim...
  4. AT--o

    Sub that takes the value of a function

    Hi. In excel 2007. My function takes its arguments from cells on the same row that it is inserted. I just copy it down. The problem is I need to change the Interior of this cell (the one containing the function) according to values that while taken from operations between the arguments are not...
  5. AT--o

    Function .Interior.Color

    Application.ThisCell.Font.Color = RGB(255, 0, 0) 'WORKS. Application.ThisCell.Interior.Color = RGB(255, 0, 0) 'DOESNT WORK. Can the Interior of a cell be changed in a Function?
  6. F

    Need function to set cell color

    I have a subroutine that looks at 3 cells to get an R, G and B value, then fills a pre-defined range of cells with that color (using this: Private Sub Worksheet_Change(ByVal Target As Range) ' error checking here Range("C3:E5").Interior.Color = RGB([A1].Value, [B1].Value, [C1].Value) End Sub...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

This Week's Hot Topics

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
Top