Changing colors in EXCEL Cells Automatically
Posted by Claude Carlson on July 30, 2001 11:47 AM
I am doing DDE exchange between EXCEL and a PLC.
The cells are automatically updated every 5 seconds
with data that represents temperature. no Problem..
No user intervention or keyboard or mouse is used to
change the data. Its automatic and works fine.
I would like the cell background color to change to red
when the value is greater than 80, and back to green
when is is below 80... HELP!!