need cell to change color for only 10 min whenever it changes its value dynamically.

[mahe1188]

Hello Excel experts,

Need of cell color change for only 10 minutes whenever it changes its value dynamically.

let say in brief,

A1 cell value changes dynamically not by manually.

so when this a1 cell value changes I need it color to be changed for only 10 minutes and after that again it should come to original color

A1 = 3 ,changes color to green for 10 min ,then comes back to original white color.

A1=5,changes to color green for 10 min ,then comes back to original white color

like this....

HELP me plz !!!!

[bharbir]

Use this Macro in conjunction with conditional formatting

Macro would be as below

Please Login or Register  to view this content.

and the conditional formatting would be something like
IF(NOW()<(D1 + 0.007), 1, 0)