Flashing Columns

[manav1103]

Sir,

In one sheet I have following 4 range for eg:

In range A3:A10 I have certain value and In range B3:B10 there is data. I want a macro that flashes the cell in green if any value in range B3:B10 increases from corresponding value in range A3:A10 and in red in it decreases as compared to range A3:A10.

Similarly for range E3:E10 which is the initial data and F3:F10 in which color changes if value changes as compared to E3:E10.

Time of flashing can be 10 secs.

Please help.

 

[Michael M]

you do realise that this will impact on the perfomance of your worksheet....and you will be unable to do other work on that worksheet while cell is flashing.
AND
It will drive any other user crazy !!!
You would be better to look at conditional formatting to do this (without flashing)