Flashing cell!

[danjuma]

Hello,

Just wondered if anybody has a macro code for making a cell flash when a condition is met. For example, cell A11 flashes in red when cell B7 = cell K8, and stop flashing when B7 no longer equals cell K8.

Many thanks.

[silver]

Can't help with code, but you could do this clumsily with conditional formatting...

You'd need a cell that counts the passage of time in seconds. For example, use this formula (posted on the forum by Gary) to convert the data from the countdown clock in D2 to seconds:

=IF(LEFT(D2)<>"-",(HOUR(D2)*3600)+(MINUTE(D2)*60)+SECOND(D2),-((HOUR(SUBSTITUTE(D2,"-",""))*3600)+(MINUTE(SUBSTITUTE(D2,"-",""))*60)+SECOND(SUBSTITUTE(D2,"-",""))))

Now, in your conditional formatting formula, include a requirement that the last/rightmost digit of that second-counting cell must be 2,4,6,8 or 0. That should make the conditional formatting flash on and off each second when the other criteria are met.

Silver

[mak]

Hi this might help

http://www.ozgrid.com/forum/showthread.php?t=80432

[danjuma]

Thanks silver and mak. Will have look at your suggestions.

Cheers.

[Ian]

Wouldn't using a macro to make the a cell flash prevent you updating any cells ?

[danjuma]

Wouldn't using a macro to make the a cell flash prevent you updating any cells ?

Ha Ian,

You might be right. I did find some macro code on the web which I modified and used to test and I must say it did behave funny when connected to BA. Anyway, I think I will forgo the flashing cell business for now and just settle for the cell background to be filled and a sound to be played (I think I have a macro for the sound bit)

Cheers
Dan

[osknows]

You could cheat....assume you want cell A1 to flash if B1 is true

In A1 enter =IF(B1=TRUE,MOD(SECOND(NOW()),2)=0,FALSE)

then set the conditional format of cell A1 to whatever colour you want if A1 =TRUE

[osknows]

Sorry, should have said this will only change colour after each re-calc