I have 50 computers with Kaspersky installed in each in my office. I made an excel chart with the following headers:
Column A Column B Column C Column D Column E Column F Row_1 System_Name User Antivirus Exp_DT Remaining Days Status Row_2 Pluto XYZ Kasper 21/jan/2020 1 ALERT Row_3 Venus ABC Kasper 4/Jan/2021 350 GRIN
I have used nested IF in col F(STATUS) to change the TEXTVALUE from "GRIN" to "ALERT" when number of days remaining comes down to 10 and below.
Now i want to Flash the cell in entire range from F2:F51 whenever the text changes from "GRIN" TO "ALERT".
I also want two Form Control buttons as : "StartBlink" and "Stopblink". On clicking the "StartBlink" button, all "ALERT" texted cell in the range should start blink.
Regards and thanks.
I have used Conditional formatting to colour the text but FLASH option is not there and i do not know vba. So any code will be of immense help.