Flashing/Blinking cell when certain value

Hi,

I have searched for VBA code to make cell K49 (in the attached skeleton workbook) flash/blink red when it equals 'Standard weldolet does not exist'. When I apply code i found on the net, i got excel errors (not VBA errors).

Can someone please assist me with this feature.

On a second note, is it possible to make a cell flash/blink if it was a particular colour. Eg, if i used conditional formatting in a particular cell and the cell turned red at a certain value - is there a way to make red cells blink. (Not value dependent.)

Hi a-man,

I think I may be able to help you. I only have access to Excel 2003, and I had a lot of trouble with your workbook (not your fault). I kept getting a runtime error where no runtime error should occur. I stopped using your file and did my development in my own Excel 2003 file that has the same 'Sheet Name' as yours and has a similar merged cell at 'K49:K50'.

1. The attached workbook starts a timer when it is opened. When 'Standard weldolet does not exist' is in 'K49' the cell blinks red.

2. From the research I've done, a solution to your second question is best accomplished using VBA code to simulate 'CONDITIONAL FORMATTING'.
The workbook has a range of cells with 'CONDITIONAL FORMATTING'. Two additional ranges use the values in the 'CONDITIONAL FORMATTING' range and use VBA to simulate 'CONDITIONAL FORMATTING'. When a simulated cell is RED and the timer is running, the simulated cell flashes RED.

I hope this helps.

Lewis