Results 1 to 5 of 5

Change Interior Color using Cell Value

Threaded View

  1. #1
    Forum Contributor PY_'s Avatar
    Join Date
    09-23-2008
    Location
    Houston
    MS-Off Ver
    Office 2016
    Posts
    289

    Change Interior Color using Cell Value

    I am trying to adjust a cell's color using RGB. I know how to force the color using the RGB in vba but is there a way to do it based on a cells value?


    This is the code i am trying to write:

    Sub test2()
    Range("B3").Interior.Color = RGB((Range("C3").Value))
    End Sub
    The value of Range("C3") = "(112, 133, 119)" (without the quotes)
    Last edited by PY_; 03-23-2011 at 01:08 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1