+ Reply to Thread
Results 1 to 3 of 3

Automatic color change of a rectangle when cell changes.

Hybrid View

  1. 03-17-2015, 07:42 AM #1
    NeedForExcel
    NeedForExcel is offline
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,879

    Re: Automatic color change of a rectangle when cell changes.

    Are you not considering using Conditional Formatting, by changing the Cell Border color instead of the Rectangle?
    Cheers!
    Deep Dave
    Reply With QuoteRegister To Reply
  2. 03-17-2015, 08:04 AM #2
    pauldobie1966
    pauldobie1966 is offline
    Registered User
    Join Date
    03-16-2015
    Location
    memphis
    MS-Off Ver
    2003
    Posts
    2

    Re: Automatic color change of a rectangle when cell changes.

    Hi
    Thank you for your quick response.
    I cant use CF because the rectangle I am using is layered on top of a picture image in my document.
    I have used CF in many cases in the document and so that is why I have used the macro.
    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. Automatic Text Color Change?
    By newguy91401 in forum Excel General
    Replies: 1
    Last Post: 07-16-2009, 02:40 PM
  2. [SOLVED] Automatic Color Change
    By Chris in forum Excel General
    Replies: 4
    Last Post: 03-30-2006, 04:25 AM
  3. How do I change the format/cell/border/automatic color to black
    By tanya in forum Excel General
    Replies: 1
    Last Post: 03-06-2006, 04:10 PM
  4. [SOLVED] RE: Automatic Color Change
    By Gary''s Student in forum Excel General
    Replies: 0
    Last Post: 02-04-2006, 03:10 PM
  5. HOW DO I CHANGE THE AUTOMATIC BORDER COLOR IN EXCEL?
    By mhbento in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-16-2005, 06:06 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1