Can I FLASH an error message on and off?

[Barry Katcher]

I have two numbers in cells A1 and A2. I have a formula in cell A3 that returns either "O.K." or "Discrepancy", depending on whether these two numbers are the same or are not the same.
My question is, can I use conditional formatting or some other function to FLASH the message in A3 on and off, either by switching background colors or text colors or both?
Thanx in advanx.

 

[Jack in the UK]

Hi Steve

No sadly not Excel can not without the delivery of VBA, you need some method of timing, there as few ways, as I posted is simplest but the poorest method, but generally gives desired results.

Excel functions and tools in front page can not carry out actions, only VBA can, the back bone to excel

Hope this helps.

Let me know if I can assist more

Jack