There is a wealth of info on how to make cells flash using VBA code, but everything I can find assumes you want the cell to flash all of the time.
I am working on displaying alarms in a worksheet and have the alarm inicator cell fill changing from green to red using conditional formatting and an audible alrm sounding based on whether a value in a reference cell is True or False.
Now I want to make the alarm indicator cell flash red and white and would like to use an "If" statement that references the same cells as the audio event.
Is there any way I can make the cell flash while the reference cell value = "True" and not when the value = "False"?
Bookmarks