In the MICROSOFT EXCEL program - the function of blinking thecell, and setting the color (under a certain condition IF)
Right place for such suggestion is Excel user voice https://excel.uservoice.com/, here are ideas of how to do TechComm itself better.
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 :
Sub Blinking_Status()Dim BlinkingCells As Range
For Each BlinkingCells In Range("Table1[Status]")
If BlinkingCells = "On Leave" ThenBlinkingCells.Interior.Color = 255 'RedElseIf BlinkingCells = "On Duty" ThenBlinkingCells.Interior.Color = 14395790 'BlueElseIf BlinkingCells = "Waiting" ThenBlinkingCells.Interior.Color = 65535 'YellowEnd IfNext BlinkingCells
Application.OnTime Now + TimeValue("00:00:06"), "Blinking_Status", , TrueEnd Sub
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.