title: Excel: Set background color of cell and text color with rgb
body: <p>I'm write a program that change font and background color due to user request. after received <strong>backgroundColorData</strong> and <strong>textColorData</strong> 
  i did like to change colors due to user request but i feel there is a better way to make it then what i choose to do (my code is maybe repeating itself)
  other issue i didn't find an answer for is how to make textColor/backgroundColor more "red" or more "blue"</p>
  
  <pre><code>  Select Case backgroundColorData
          Case Is = "Black"
              Selection.Interior.Color = RGB(0, 0, 0)
          Case Is = "Red"
               Selection.Interior.Color = RGB(255, 0, 0)
          Case Is = "Blue"
               Selection.Interior.Color = RGB(0, 0, 255)
          Case Is = "White"
               Selection.Interior.Color = RGB(255, 255, 255)
    End Select
  
  
      Select Case textColorData
          Case Is = "Black"
              Selection.Font.Color = RGB(0, 0, 0)
          Case Is = "Red"
               Selection.Font.Color = RGB(255, 0, 0)
          Case Is = "Blue"
               Selection.Font.Color = RGB(0, 0, 255)
          Case Is = "White"
               Selection.Font.Color = RGB(255, 255, 255)
       End Select  
  </code></pre>
  
  <p>Any help would be appreciated.</p>