avichandana
01-20-2020, 05:27 AM
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.
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.