+ Reply to Thread
Results 1 to 5 of 5

Change cell's interior color and font

  1. #1
    Registered User
    Join Date
    06-22-2011
    Location
    location
    MS-Off Ver
    Excel 2007
    Posts
    47

    Change cell's interior color and font

    Hi,

    I try to change the cell's interior color and the font color when a change is made via userform
    Could someone help me, please?
    I appreciate your help!

    test file attached

    tim
    Attached Files Attached Files
    Last edited by tim5; 09-22-2011 at 06:21 AM.

  2. #2
    Registered User
    Join Date
    06-22-2011
    Location
    location
    MS-Off Ver
    Excel 2007
    Posts
    47

    Re: Change cell's interior color and font

    Does anyone have any idea...

    thakk you, tim

  3. #3
    Forum Contributor ianh's Avatar
    Join Date
    11-19-2010
    Location
    Newcastle
    MS-Off Ver
    Excel 2010
    Posts
    114

    Re: Change cell's interior color and font

    Is the change dependant on a variable? ie if certain values are entered the colour is something specific?

    If not and you just want to highlight the cells you could but the following code at the end of the userform script to change the colour.

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    06-22-2011
    Location
    location
    MS-Off Ver
    Excel 2007
    Posts
    47

    Re: Change cell's interior color and font

    hi Ianh,
    I tried before this solution, it colors my selected cell. With my UserForm I "select" a cell and update others! these cell(s) updated I want to have it colored!
    Thank you for your help!

    tim

  5. #5
    Registered User
    Join Date
    06-22-2011
    Location
    location
    MS-Off Ver
    Excel 2007
    Posts
    47

    Re: Change cell's interior color and font

    hi,
    I think I found a solution, If anyone is interested ...
    Please Login or Register  to view this content.
    tim

+ Reply to Thread

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