Excel

  sms 22:46 01 Mar 11
Locked

I have a cell value from a sensor that is constantly changing up or down in values. I want to monitor this cell and have message pop up if the cell value is decreasing or increasing. Any ideas pleasr

  Graham. 00:17 02 Mar 11

Use a sensible TITLE? I don't have time to plough through vague titles.

  MAJ 00:36 02 Mar 11

Have you tried using Conditional Formatting to change the colour of the Cell when the value of the Cell changes? For example, if the Cell Value is > 3 then colour the Cell Red, if the Cell Value is < 3 then colour the Cell Green.

  VoG II 08:03 02 Mar 11

You may want to look at event procedures click here

  sms 09:14 02 Mar 11

If everything is so vague then we dont you go somewhere else and leave the sarcy remarks at home

This thread is now locked and can not be replied to.

Huawei P10 review

1995-2015: How technology has changed the world in 20 years

An overview: What leading creative agencies are doing to improve diversity

New iPad, iPhone SE & Red iPhone 7 on sale now