+ Reply to Thread
Results 1 to 4 of 4

Code to change row (cell range) color with or without button

  1. #1
    Registered User
    Join Date
    10-21-2017
    Location
    USA
    MS-Off Ver
    2016
    Posts
    3

    Code to change row (cell range) color with or without button

    I'm working on a spreadsheet that uses colors for quality of items (Good=green, Fair=yellow, Poor=red or N/A=gray). Each row will need to change to the color of the rating for that row and needs to stay within columns A-J. Also, if I select a different rating for the row, the color needs to change for that rating. I would prefer to accomplish this by simply selecting the appropriate box for the row rather than adding a radial button in each box (very time consuming). I have attempted with conditional formatting and with vba codes and with grouping radial buttons but I can't seem to get it right. Here is an example of my worksheet:https://flic.kr/p/ZBjhvq

  2. #2
    Valued Forum Contributor WasWodge's Avatar
    Join Date
    08-02-2010
    Location
    Hampshire,England
    MS-Off Ver
    Office 365 and Office 2010
    Posts
    882

    Re: Code to change row (cell range) color with or without button

    Cross-posted without a link here.
    If my solution worked (or not) please let me know. If your question is answered then please remember to mark it solved

    Computers are like air conditioners. They work fine until you start opening windows. ~Author Unknown

  3. #3
    Registered User
    Join Date
    10-21-2017
    Location
    USA
    MS-Off Ver
    2016
    Posts
    3

    Re: Code to change row (cell range) color with or without button

    Removed comment. Cross posted and replied to wrong forum. My apologies.
    Attached Images Attached Images
    Last edited by asd.sparky; 10-21-2017 at 11:32 PM. Reason: wrong reply

  4. #4
    Registered User
    Join Date
    10-21-2017
    Location
    USA
    MS-Off Ver
    2016
    Posts
    3

    Re: Code to change row (cell range) color with or without button

    Quote Originally Posted by WasWodge View Post
    Cross-posted without a link here.
    It seems my first post as a new member has already failed to comply with the forum rues. I apologize for missing that requirement. I did cross post but I did not intentionally break the rules. I assure this will not be the case again. Thank you for alerting the mods of my mistake.

    Mods: please feel free to remove this post. Thank you.
    Last edited by asd.sparky; 10-21-2017 at 11:46 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Change the fill color of a specific cell by the click of a button
    By DuxAhx in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-18-2017, 05:31 AM
  2. Change color of macro button based on cell value
    By JayUSA in forum Excel General
    Replies: 3
    Last Post: 05-18-2017, 04:05 AM
  3. Trying to change shape color when selecting toggle button - Code gives Error
    By JJFletcher in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-01-2016, 01:38 PM
  4. Change a Range's cell background color to that of another cell's cond. format color
    By kamelkid2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-31-2014, 12:57 PM
  5. [SOLVED] Change cell color depending on cell color, error in code
    By mushedpotatos in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-25-2014, 04:20 AM
  6. change fill color of a range of cells based on color of a cell?
    By DarMelNel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-20-2014, 04:48 PM
  7. [SOLVED] vba code to change the cell color by looking in a range that contains the color index valu
    By ckklconner in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-24-2013, 09:15 AM

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