In MICROSOFT EXCEL - the function of blinking the cell, and color - certain condition IF

In MICROSOFT EXCEL - the function of blinking the cell, and color - certain condition IF
0

Upvotes

Upvote

 Nov 11 2019
3 Comments (3 New)
Closed

In the MICROSOFT EXCEL program - the function of blinking the
cell, and setting the color (under a certain condition IF)

Comments

Right place for such suggestion is Excel user voice https://excel.uservoice.com/, here are ideas of how to do TechComm itself better.

Community Manager
Status changed to: Closed

Thank you for your feedback. This ideas board is intended for ideas for the Microsoft Tech Community and not product specific. If you would like to post an idea for the Excel Community, please do so on their UserVoice here : 

Copper Contributor

Sub Blinking_Status()
Dim BlinkingCells As Range

For Each BlinkingCells In Range("Table1[Status]")

If BlinkingCells = "On Leave" Then
BlinkingCells.Interior.Color = 255 'Red
ElseIf BlinkingCells = "On Duty" Then
BlinkingCells.Interior.Color = 14395790 'Blue
ElseIf BlinkingCells = "Waiting" Then
BlinkingCells.Interior.Color = 65535 'Yellow
End If

Next BlinkingCells

Application.OnTime Now + TimeValue("00:00:06"), "Blinking_Status", , True
End Sub