I am using the conditional formating in excel, which is found under Format:/Conditional Formating I have a cell and I want to be alerted when the value of my cell is larger than the value of another cell. Right now, I have setup my conditional formating to turn the cell color to 'red' so that I am alerted to the conditions that I am looking for. How do I get a 'blinking red' cell instead of the solid 'red' cell? Is it possible to have a blinking cell in excel? Thanks
Surprisingly it is not a feature, or at least I couldn't find it. A possible solution I found on the net would be to use VBA : To create a blinking cell: (Created by Bill Manville) If you define a new Style (Format / Style / Flash/ Add ) and apply that style to the cells you want to flash, paste the following code into a module sheet and run the procedure Flash from Auto-Open if desired you will get the text flashing alternately white and red. Code: Dim NextTime As Date Sub Flash() NextTime = Now + TimeValue("00:00:01") With ActiveWorkbook.Styles("Flash").Font If .ColorIndex = 2 Then .ColorIndex = 3 Else .ColorIndex = 2 End With Application.OnTime NextTime, "Flash" End Sub Sub StopIt() Application.OnTime NextTime, "Flash", schedule:=False ActiveWorkbook.Styles("Flash").Font.ColorIndex = xlAutomatic End Sub