+ Reply to Thread
Results 1 to 2 of 2

Color of shapes from cell content

  1. #1
    Registered User
    Join Date
    06-03-2014
    MS-Off Ver
    2007
    Posts
    87

    Color of shapes from cell content

    Hi,

    I made a little macro to change the color of a circle whether my cell value is positive or negative.

    However, I'm looking for a way to code it in ThisWorkbook sheet so that the code runs by itself every time the cell value changes.

    Please Login or Register  to view this content.
    Last edited by SIMBAtheCAT; 07-04-2014 at 01:55 PM.

  2. #2
    Forum Expert
    Join Date
    06-18-2004
    Location
    Canada
    MS-Off Ver
    Office 2016
    Posts
    1,474

    Re: Color of shapes from cell content

    It looks like your code changes it to the same colour, whether positive or negative. Do you actually want to change it to one colour if positive, and another colour if negative. If so, assuming that negative should be red and positive should be black, try entering the following code in the code module for the sheet (right-click the sheet tab, select 'View Code', copy/paste the code, and Alt+Q)...

    Please Login or Register  to view this content.
    Hope this helps!

+ 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 cell color if content changes
    By DonaldJ in forum Excel General
    Replies: 3
    Last Post: 04-18-2014, 10:21 AM
  2. Need Help with Count by Cell Color and Content
    By sjhoward60 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-11-2014, 03:28 PM
  3. Change color of shapes based on cell values.
    By rkostner in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-24-2013, 05:55 PM
  4. How to color a cell according to its content
    By hkBattousai in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-30-2010, 09:40 AM
  5. can we color a cell content partly?
    By J_J in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-22-2005, 08:06 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