+ Reply to Thread
Results 1 to 4 of 4

Make specific cells blink

  1. #1
    Forum Contributor
    Join Date
    04-11-2012
    Location
    Canada
    MS-Off Ver
    Excel 2007 & 2010
    Posts
    100

    Question Make specific cells blink

    Hi everyone...

    I was trying to create blinking cells for my spreadsheet, but haven't had any success so far.

    I have several different categories such as (Purchasing, Drafting, Appliances, etc) that are entered into a database and then automatically transferred into an Aerial View.
    My goal is to make a cell blink one color if it says "Purchasing", another color if it says "Drafting", and so on...

    That means, if i open my Aerial View Line 2 Tab, Range("B8:D8") would be flashing one color, Range("F8:H8") would be flashing another color, and so on...

    Please see attachment to get an idea...Thank you!!

    Any help is much appreciated...
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-10-2008
    Location
    Northeast Pennsylvania, USA
    MS-Off Ver
    Excel 2007
    Posts
    2,387

    Re: Make specific cells blink

    questionguy,

    See if something below will help you get started in the right direction:

    Cell text blinking
    http://www.atlaspm.com/faqformatblink.html#30

    Blinking Text In Excel
    http://www.cpearson.com/excel/BlinkingText.aspx

    How can I make a cell (or some other object) flash?
    http://www.tmehta.com/tmxl/dbfind_byid.asp?id=14
    Have a great day,
    Stan

    Windows 10, Excel 2007, on a PC.

    If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

  3. #3
    Forum Contributor
    Join Date
    04-11-2012
    Location
    Canada
    MS-Off Ver
    Excel 2007 & 2010
    Posts
    100

    Re: Make specific cells blink

    Thanks stanleydgromjr. I went through these pages before and one of them worked fine, except i could only do it for a range with one cell...
    What I am trying to achieve is little more complicated..

  4. #4
    Forum Contributor
    Join Date
    04-11-2012
    Location
    Canada
    MS-Off Ver
    Excel 2007 & 2010
    Posts
    100

    Re: Make specific cells blink

    This is an advance problem... I would really appreciate if there's anybody that could help...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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