Excel Cell Flashing

ITsolutionWizard
ITsolutionWizard used Ask the Experts™
on
I want to make a few cells flashing. Hopefully to have something that right click the cell and select Flashing Module or something.
Something easy to use.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Scott CSenior Engineer
Commented:
Nothing by default, but you can do this with a macro.

https://excel.tips.net/T002134_Flashing_Cells.html

Here is basically the same thing, but with an explanation on why you SHOULDN'T do this.

http://www.excelsupersite.com/how-to-make-a-cell-flash-in-excel/
Managing Director/Excel VBA Developer
Distinguished Expert 2018
Commented:
Assuming you want A1 cell to Flash, you can use below vba and run Flash_Cells:
Sub Flash_Cells()
    Dim xColor As Integer
    Dim xCount As Integer
    Dim xSpeed As Double
    Dim xStart As Double
    Dim xDelay As Double
    Dim xRg As Range
    Dim xTxt As String
    Dim xCell As Range
    On Error Resume Next
    If ActiveWindow.RangeSelection.Count > 1 Then
      xTxt = ActiveWindow.RangeSelection.AddressLocal
    Else
      xTxt = ActiveSheet.UsedRange.AddressLocal
    End If
    Set xRg = ActiveSheet.Range("A1")
    If xRg Is Nothing Then Exit Sub
    For Each xCell In xRg
        If xCell.Value > 4 Then
            xSpeed = 0.6
            Do Until xCount = 6 'Change the time here, how long you want it to flash
                DoEvents
                xStart = Timer
                xDelay = xStart + xSpeed
                Do Until Timer > xDelay
                    DoEvents
                    xRg.Font.Color = vbRed
                Loop
                xStart = Timer
                xDelay = xStart + xSpeed
                Do Until Timer > xDelay
                    DoEvents
                    xRg.Font.Color = vbBlack
                Loop
                xCount = xCount + 1
            Loop
        End If
    Next
End Sub

Open in new window


If you want to change the period, change this line:
Do Until xCount = 6 'Change the time here, how long you want it to flash

**eenookami**: Code above was sourced from: https://www.extendoffice.com/documents/excel/3676-excel-make-cell-flash.html#a1
Flashing-Cell.xlsm

Author

Commented:
Hi experts, both answers I already found on Google. What I hope to get is something easier to work with.

It is for non technical users....
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

ShumsManaging Director/Excel VBA Developer
Distinguished Expert 2018

Commented:
Then supply Sample Workbook with expected result
Scott CSenior Engineer
Commented:
Then the answer is "no".  There isn't a "non-technical" way of doing this.
Scott CSenior Engineer

Commented:
Here's a thread on EE that I stumbled across.

https://www.experts-exchange.com/questions/28193199/In-Excel-make-cell-blink-and-or-change-colors-under-certain-conditions.html

See if this is more of what you're looking for.

Edit...Nah not really.  Still uses VBA code.
Shaun VermaakSenior Consultant
Awarded 2017
Distinguished Expert 2018

Commented:
Shums posted a sample workbook with VBA already added so you do not need to fiddle with the code
Shaun VermaakSenior Consultant
Awarded 2017
Distinguished Expert 2018

Commented:
Shums provided a sample workbook ready to be used

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial