I am a complete novice and need whayt is probably basic informatio.

I am creating a "live" worksheet where a column of cells contain a critical time.

Is there a way that I can set and alarm ( by making the charecters flash or shange colour) when the time reaches, say, 30 minutes to the time shown in the cell?

All help will be appreciated.

Thanks