Take sample 2 cells above highlighted cell

[pltom55]

So i have a column of data. i know how to conditionally format so it highlights it where i want. However, is it possible to get the cell's data 2 cells above the highlighted cell?
Here is a small sample set
Row # / Data
[TABLE="width: 64"]
<colgroup><col></colgroup><tbody>[TR]
[TD="align: right"]#1 1.9818[/TD]
[/TR]
[TR]
[TD="align: right"]#2 1.9818[/TD]
[/TR]
[TR]
[TD="align: right"]#3 1.9818[/TD]
[/TR]
[TR]
[TD="align: right"]#4 1.9818[/TD]
[/TR]
[TR]
[TD="align: right"]#5 1.9818[/TD]
[/TR]
[TR]
[TD="align: right"]#6 1.9818[/TD]
[/TR]
[TR]
[TD="align: right"]#7 1.9818[/TD]
[/TR]
[TR]
[TD="align: right"]#8 1.9817[/TD]
[/TR]
[TR]
[TD="align: right"]#9 0.843

[/TD]
[/TR]
</tbody>[/TABLE]
The .0843 (row #9)gets highlighted through conditional formatting.
I want the 1.9818 (row #7) to be placed in P1 and then find the next highlighted cell and place the cell's data 2 cells above in P2.

Thanks for your help