Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to Blink a cell in Excel if negative or red colour
Is it possible to make cells that become negative on calculation or red in
colour to Blink. I have a summary sheet that totals calculates from several others. The cells turn negative and red when calculating a deficit. I would also like them to blink Please advise in not to tech terms how I may achieve this. Many thanks garyB |
#2
|
|||
|
|||
Gary, search for Blinking cells there are lots of posts on this topic. -- greg7468 ------------------------------------------------------------------------ greg7468's Profile: http://www.excelforum.com/member.php...fo&userid=9031 View this thread: http://www.excelforum.com/showthread...hreadid=381169 |
#3
|
|||
|
|||
Gary, from previous posts on this topic, you may find this will help you out, http://snipurl.com/cpo7 HTH. -- greg7468 ------------------------------------------------------------------------ greg7468's Profile: http://www.excelforum.com/member.php...fo&userid=9031 View this thread: http://www.excelforum.com/showthread...hreadid=381169 |
#4
|
|||
|
|||
How about using conditional formatting for this one. Blinking can cause
issues for epileptics (as I recently was told). Go to format - Conditional formatting when you've selected the cell you want to format. "garygadget" wrote: Is it possible to make cells that become negative on calculation or red in colour to Blink. I have a summary sheet that totals calculates from several others. The cells turn negative and red when calculating a deficit. I would also like them to blink Please advise in not to tech terms how I may achieve this. Many thanks garyB |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pasting Word table cell with paragraph markers into single Excel c | Excel Discussion (Misc queries) | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
display negative values as a blank cell in Excel | Excel Discussion (Misc queries) | |||
Excel: how to formulate conditional cell references | Excel Worksheet Functions | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) |