+ Reply to Thread
Results 1 to 14 of 14

Cell colour change code not activating

  1. 06-09-2014, 01:06 PM #1
    Groovicles
    Groovicles is offline
    Forum Contributor
    Join Date
    07-29-2013
    Location
    Oshawa
    MS-Off Ver
    Excel 2010
    Posts
    660

    Cell colour change code not activating

    Hi everyone,

    I have the following code:

    Please Login or Register  to view this content.
    I think the code is correct but the cell colour is not changing based on the dropdown value in the cell. What have i done wrong?

    Thanks!
    Reply With QuoteRegister To Reply
  2. 06-09-2014, 01:21 PM #2
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Cell colour change code not activating

    Maybe?:

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 06-09-2014, 01:35 PM #3
    Winon
    Winon is offline
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Cell colour change code not activating

    Hello Groovicles,

    Or maybe some as per the attached sample Workbook.

    Regards.
    Attached Files Attached Files
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
    Reply With QuoteRegister To Reply
  4. 06-09-2014, 01:59 PM #4
    Groovicles
    Groovicles is offline
    Forum Contributor
    Join Date
    07-29-2013
    Location
    Oshawa
    MS-Off Ver
    Excel 2010
    Posts
    660

    Re: Cell colour change code not activating

    Hi

    Thanks very much! The colours are coming up, but for some reason case eee - eee seems to be copying the colour of the previous selection. So if i selected aaa and then eee - eee then eee - eee will be the same colour as aaa. Its the same thing for all other selections and only occurs with eee - eee. Weird huh? Any ideas?
    Reply With QuoteRegister To Reply
  5. 06-09-2014, 02:12 PM #5
    Winon
    Winon is offline
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Cell colour change code not activating

    Hello Groovicles,

    O.K. I see your issue.

    Please try this Workbook.

    Regards.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 06-09-2014, 02:36 PM #6
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Cell colour change code not activating

    @ Winon - nice workaround. I'm still confused why the first code did not work??
    Reply With QuoteRegister To Reply
  7. 06-09-2014, 02:44 PM #7
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Cell colour change code not activating

    Another:

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  8. 06-09-2014, 02:49 PM #8
    Winon
    Winon is offline
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Cell colour change code not activating

    @ JOHN H.DAVIS,

    Thank you for the feedback.

    Beats me as well, since your code, hard coded and all, did not present the problem as described by Groovicles.

    What I did was to provide Groovicles with a list in which s/he may change the criteria to match.

    In any case, it is a comendable contribution from your side!

    Regards.
    Reply With QuoteRegister To Reply
  9. 06-10-2014, 08:07 AM #9
    Groovicles
    Groovicles is offline
    Forum Contributor
    Join Date
    07-29-2013
    Location
    Oshawa
    MS-Off Ver
    Excel 2010
    Posts
    660

    Re: Cell colour change code not activating

    Hi Winon,

    Thanks very much for your help! I see the different method you took. Unfortunately, I'm getting the same strange results as with John's. eee-eee gets the same colour as was shown just previous to it being selected. This is so strange.
    Reply With QuoteRegister To Reply
  10. 06-10-2014, 08:26 AM #10
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Cell colour change code not activating

    Did you try Post#7?
    Reply With QuoteRegister To Reply
  11. 06-10-2014, 09:02 AM #11
    Winon
    Winon is offline
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Cell colour change code not activating

    Hello Groovicles,

    Check and see if you do not perhaps have Conditional Formatting applied to that Cell. If so, delete the Conditional Formats.

    Regards.
    Reply With QuoteRegister To Reply
  12. 06-10-2014, 02:38 PM #12
    Groovicles
    Groovicles is offline
    Forum Contributor
    Join Date
    07-29-2013
    Location
    Oshawa
    MS-Off Ver
    Excel 2010
    Posts
    660

    Re: Cell colour change code not activating

    hi everyone,

    No conditional formatting, and i tried post #7 with the same result. This is unbelievable!!! I think i might just leave it.
    Reply With QuoteRegister To Reply
  13. 06-10-2014, 03:02 PM #13
    Winon
    Winon is offline
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Cell colour change code not activating

    Hello Groovicles,

    Thank you for the confirmation.

    Please confirm if it does it also on the Workbook I had sent you.

    Regards.
    Reply With QuoteRegister To Reply
  14. 06-10-2014, 03:28 PM #14
    Winon
    Winon is offline
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Cell colour change code not activating

    Hello Groovicles,

    I have just checked the Workbook as posted in Post#5, and it works just fine!

    I would suggest you open Excel, and run Microsoft Office Diagnostics. It may take a while, but I suspect that it will solve your problem.

    Please see this link how to (hopefully), fix your problem.

    http://www.sevenforums.com/tutorials...m-repairs.html

    Or: http://answers.microsoft.com/en-us/o...f-89abbeb77942

    Regards.
    Last edited by Winon; 06-10-2014 at 03:35 PM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA code to tell an object to change colour depending on figure in cell
    By Muzza86 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-29-2014, 07:29 AM
  2. Help amending a macro code to colour change of an amendend cell from its original value
    By susanhorn in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-14-2013, 02:22 AM
  3. [SOLVED] VBA to immediately change the colour of a cell depending on the code placed in another cel
    By Phil Payne in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-13-2013, 01:15 PM
  4. Using VB Code to change cell colour on back of formula
    By Twaddy in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 09-30-2010, 04:29 PM
  5. VB Code to change cell colour by entering a word
    By Twaddy in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 09-24-2010, 07:38 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1