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?
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD]200[/TD]
[TD]300


[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Thanks!

 

[Fluff]

How are the cells getting highlighted?