Use another column as the signal column. Make its value 1 if paid or zero if
unpaid. Use sumproduct using this column and the value column. Use
conditional formatting to turn the value red if the signal is zero.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Dennis Shaw" wrote in message
...
Can I ask in a formula to not add a number in an array of a certain colour
until the colour is changed. eg unpaid is in red, when paid change to
black.