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.

How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…

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

Alex Chinneck’s giant ice cube Christmas tree at Kings Cross

Apple rumours & predictions 2017: The iPhone 8, new iPads, and everything else you should expect fr7…