Forum Discussion
unique macro
Is it possible to write a macro that causes a cell value to flash or blink if the cell value fails to meet a maximum or minimum value?
8 Replies
Instead of flashing or blinking (which can be dangerous for some users, and irritating to others), you can use conditional formatting to make the cell stand out - you can change the cell's font style, fill color and/or borders.
- I appreciate your suggestion, but I prefer to have the cell value flashing or blinking. That is more "eye-catching" than simply changing font and/or cell color. BTW, I'm the only one that will be using the spreadsheet, so there isn't a concern that it would be dangerous or irritating to others. So, my question still stands, is my preference possible?
It's possible, but I still strongly recommend against it. It would require VBA code to run every second or so, and this will most likely interfere with the normal operation of the workbook.
