I have a column in which a dollar amount (currency) is entered. That column is totaled at the bottom of the column but I want to have the values entered after reaching a specific total (say $5,000) be red. In other words, one $5000 is reached all other subsequent values entered in the column would be red.

ex

$3500
$4000
$4500

$5000
$5500
$6000
etc

thanks for any help