I have a column (say Column B) of cells that will display the words "Expiring soon" based on
the values in another column (say Column A) of cells.
Cells in Column B contain formula to determine when the words "Expiring soon" should be displayed. Cells in Column A contain numbers which represent number of days.
I tried to find from various Excel forums to get VBA coding that can make the words "Expiring soon" to blink. I tried to adapt a set of VBA coding which is closest to what I want, but it does seem to work.
I need some experts' help. I've attached a sample Excel file to illustrate what I want to achieve. Any help from Excel experts is very much appreciated. Thank you.
KS Chan
Bookmarks