Excel make cell flash red

Solved/Closed
hugrl Posts 4 Registration date Thursday February 5, 2009 Status Member Last seen February 23, 2009 - Feb 9, 2009 at 12:19 PM
 Rjc - Mar 13, 2020 at 08:05 AM
Hello,
In Excel I can make cell red when formula is greater than 4 but how do I GET CELL TO FLASH Office 2003

And can you in same spreadsheet link page with name under dates to sheet containing name in row to a number under same date IE j bloggs under 30 Mar in weekly sheet to a 1 under same date in monthy sheet every time name appears ( 160 name to go in)

2 replies

Private Sub Flash_Cells()

Dim FlashColor As Integer
Dim MakeFlash As Range
Dim x As Integer
Dim TheSpeed
Dim i

'Just a random range of cells. Change it to whatever you want.
Set MakeFlash = Range("A1,C6,F3,H4")

For Each I In MakeFlash

If i.Value > 4 Then

FlashColor = 3 'Set the color to red

'Make the cell range flash fast: 0.01 to slow: 0.99
TheSpeed = 0.2

'Flash 7 times
Do Until x = 7

DoEvents
Start = Timer
Delay = Start + TheSpeed
Do Until Timer > Delay
DoEvents
MakeFlash.Interior.ColorIndex = FlashColor
Loop
Start = Timer
Delay = Start + TheSpeed
Do Until Timer > Delay
DoEvents
MakeFlash.Interior.ColorIndex = xlNone
Loop
x = x + 1
Loop

End If
Next i

End Sub
63
hugrl Posts 4 Registration date Thursday February 5, 2009 Status Member Last seen February 23, 2009
Feb 23, 2009 at 07:21 AM
thanks ok
0
I used you macro to make cells flash and It works great.I have 7 cells listed c3,d3,e3,f3,g3,h3,i3 They all flash can you tell how to make thecell that has high number only flash. Thanks
0
Would you please tell me exactly where to insert this code? i.e. under "new module", or "alt-F11" in that window? (I'm a less than a novice)
0
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Jun 29, 2012 at 07:43 PM
depends on how you plan to use it.
0
I used in module, then "run" it.
To check the result, use side by side windows.
0