Archive of Mr Excel Message Board


Back to Forms in Excel VBA archive index
Back to archive home



How can I make a number or text blink in excel?

Posted by Elwish on May 31, 2001 2:16 AM
I am using Excel 2000, say, I want to add Cell A1 + A2, if the answer is less than 10 it should blink, how can I do that? If it is without using VB Codes it will be more useful.
Thanks

8670.html

Posted by Dominic on May 31, 2001 2:26 AM

Above Message thread has good code


Re: How can I make a number or text blink in excel?

Posted by Peter on May 31, 2001 2:43 AM


Rather than having the cell or the font "blink" (which requires VBA), I would suggest that you consider using Conditional Formatting instead.

Let's say your formula(=A1+A2) is in cell A3. Select A3, go to Format>Conditional Formatting, select 'Cell Value Is' in the first box, 'Less Than' in the second box, type in 10 in the third box, and set the format you want.




This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.