flashing text

Does it need to flash (you will need VBA code for that) or it's enough to become red (you just need Conditional formatting for that)?

Hi Laduk..

Didn't get what you want. Can you elaborate?

Yes would like it to flash red and white or visible / not visible

Thanks

as an option

Sub Button1_Click()
Range("H6:M6").Interior.Color = 255  'change rng for yr needs
x = Timer
While Timer - x < 0.4
Wend
Range("H6:M6").Interior.Pattern = xlNone
x = Timer
While Timer - x < 0.4
Wend
Range("H6:M6").Interior.Color = 255
x = Timer
While Timer - x < 0.4
Wend
Range("H6:M6").Interior.Pattern = xlNone
x = Timer
While Timer - x < 0.4
Wend
Range("H6:M6").Interior.Color = 255
End Sub

Be aware that blinking text can cause seizures in epileptic patients

here.. continuously flashing cell (but I don't recomand this solution)

Edit: Save before closing workbook