+ Reply to Thread
Results 1 to 9 of 9

Color cells only in particular condition

  1. #1
    Registered User
    Join Date
    09-16-2019
    Location
    Italy
    MS-Off Ver
    2016
    Posts
    48

    Color cells only in particular condition

    Hello,
    i wrote a code that, when pressing a button, some cells are being colored and formatted. What i am trying to do is if a cell is already colored or formatted, it should keep it's color.
    Here is the code :

    Please Login or Register  to view this content.
    Thank you in advance.
    Last edited by Lomoo; 09-17-2019 at 06:03 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    12-14-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2007
    Posts
    439

    Re: Color cells only in particular condition

    Just check cell color before do anything.
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    09-16-2019
    Location
    Italy
    MS-Off Ver
    2016
    Posts
    48

    Re: Color cells only in particular condition

    It doesn't work..
    when the cell is colored by the default color(51, 255, 153), if i click the button, the color doesn't change and that is correct, but when the cell is colored by another color, when clicking the button, the cell instead of keeping that color, transforms it self to the defualt color..

  4. #4
    Valued Forum Contributor
    Join Date
    12-14-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2007
    Posts
    439

    Re: Color cells only in particular condition

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    09-16-2019
    Location
    Italy
    MS-Off Ver
    2016
    Posts
    48

    Re: Color cells only in particular condition

    Again the same problem..
    Maybe should i attach an image file here?

  6. #6
    Valued Forum Contributor
    Join Date
    12-14-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2007
    Posts
    439

    Re: Color cells only in particular condition

    You should attach a sample workbook (not image) and explain what you want. Please show all possible cases and the respective expected result of each case.

  7. #7
    Registered User
    Join Date
    09-16-2019
    Location
    Italy
    MS-Off Ver
    2016
    Posts
    48

    Re: Color cells only in particular condition

    The attach button doesn't work.. how can i send you my file?

  8. #8
    Valued Forum Contributor
    Join Date
    12-14-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2007
    Posts
    439

    Re: Color cells only in particular condition

    You can send the file to me via email. I have given my email address to you on private message.

  9. #9
    Registered User
    Join Date
    09-16-2019
    Location
    Italy
    MS-Off Ver
    2016
    Posts
    48

    Re: Color cells only in particular condition

    Thank you, i sent.

+ 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. [SOLVED] Color a cell If 2 other cells meet condition, undo cell color if third cell meet condition
    By aftbrah in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 10-28-2016, 01:17 AM
  2. 3 choices to change other cells color if matching condition
    By clpickett3 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-27-2016, 12:51 PM
  3. Color cells based on multiple condition
    By Blokeman in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 10-20-2015, 08:57 PM
  4. Replies: 3
    Last Post: 01-08-2014, 03:56 PM
  5. If Then Syntax to Color Cells Depending on the Condition 'Value' - possible?
    By ooos9272 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-06-2013, 03:55 AM
  6. [SOLVED] Color cells in Range based on condition.
    By gammaman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-24-2012, 10:27 AM
  7. Replies: 6
    Last Post: 07-03-2009, 05:25 AM

Tags for this Thread

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