cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

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)

Comment
Comments
SergeiBaklan
MVP
‎Nov 11 2019 02:19 PM
‎Nov 11 2019 02:19 PM

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

Sarah_Gilbert
Community Manager
‎Dec 03 2019 04:13 PM
‎Dec 03 2019 04:13 PM
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 : 

redha2205
Copper Contributor
‎Mar 02 2021 05:25 AM
‎Mar 02 2021 05:25 AM

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

Similar Ideas
No similar ideas