Select cell before different cell color

[lordrummxx1]

Hello,

I'm looking for a formula to that would select the cell value right before a cell color change. For example, assume the cell containing the number 300 below was blue, and the 100 and 200 cell are white, how would i write a formula that would highlight all of the numbers (100,200,300) but would recognize that 300 was a different color and return the cell containing 200?

100	200	300

<tbody>
</tbody>

Thanks!

 

[Fluff]

How are the cells getting highlighted?