I currently have a worksheet totaling up an amount of points (I.E. john saw
10 people and his point for this are 5) this is done over several key points
and then totaled at the bottom of the row with a SUM. Now I need to add to
this sum the issue of a negative number until it reaches 160 points and it
needs to be red in colour and changing to blue after 160 point is reached.

Thank you ahead of time