I have a conditional format for my column that highlights values from top to bottom that fit within a threshold of $35,906,142.00. The formula I am using for this condition is 

=SUM($X$2:X2) <= 35906142

It highlights before it reaches the $35,906,142.00, but there are ranked values below the last unhighlighted value that can still fit inside the threshold along with the others already counted before exceeding the $35,906,142.00. What formula should I use to include those values? The numbers must stay in this descending order however, because these are ranked by a score in another column.

​I have a conditional format for my column that highlights values from top to bottom that fit within a threshold of $35,906,142.00. The formula I am using for this condition is  =SUM($X$2:X2) <= 35906142 It highlights before it reaches the $35,906,142.00, but there are ranked values below the last unhighlighted value that can still fit inside the threshold along with the others already counted before exceeding the $35,906,142.00. What formula should I use to include those values? The numbers must stay in this descending order however, because these are ranked by a score in another column.  Read More

​