+ Reply to Thread
Results 1 to 3 of 3

make cell blink and/or change colors under certain conditions

  1. #1
    Forum Contributor
    Join Date
    12-21-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    382

    make cell blink and/or change colors under certain conditions

    Hi,

    Example: A1 = 300 (Target) (Green color)
    A2 = 145
    A3 = 275
    A4 = 375
    A5 = 165
    A6 = 225
    A7 = 355
    (It will not always be the same range of data being selected (A2:A7) may be less or more row.)


    If any cell from A2:A7 become greater than A1, I want These Cell BLINK and/or Change Colors.

    This will warn the users that the Max Target amount shown in cell A1 has been exceeded.

    Thank you for your assistance.
    My English is very poor, so please be patient >_<"

    Thanks & Regards.
    hkbhansali

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365 Version 2202
    Posts
    6,109

    Re: make cell blink and/or change colors under certain conditions

    You have a couple of choices here.

    1) If you want the cell to blink, that can only be achieved through VBA.

    2) If you simply want the fill color of a cell to change when it exceeds the value in A1, you can use Conditional Formatting.

    To do this, select A2:A100 (or however far down you think your data can go in the future) > Conditional Formatting > New Rule > Use a formula

    =A2>A$1

    Format: Fill color of your choice > OK > OK

    3) You can create Data Validation to warn the user (after entering a value) that the value exceeds A1.

  3. #3
    Forum Contributor
    Join Date
    12-21-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    382

    Re: make cell blink and/or change colors under certain conditions

    Hi 63falcondude

    I want to blink cell, VBA code required.

+ 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. Upon entry in any cell, need some fill colors to change if certain conditions met
    By ILoveStMartin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-07-2014, 02:25 AM
  2. Make cell blink
    By Oziebill in forum Excel General
    Replies: 3
    Last Post: 06-14-2012, 06:14 PM
  3. [SOLVED] Can you make a cell blink?
    By JE McGimpsey in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-06-2005, 07:05 AM
  4. [SOLVED] Can you make a cell blink?
    By JE McGimpsey in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2005, 06:05 AM
  5. Can you make a cell blink?
    By raven_guy in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  6. Can you make a cell blink?
    By raven_guy in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  7. Can you make a cell blink?
    By raven_guy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-08-2005, 03:05 PM

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