Cell Reference Error use for conditional formatting

Hello,
I am currently receiving an error while trying to reference a cell using an ActiveCell.Offset Command. I must not be using it correctly.
I cannot reference the cell directly because it is not always in the same location. and resolution ideas?
Here is the code:

Please Login or Register  to view this content.

Then I am also concerned I am not using the Variants correctly in the conditional formatting, however, I don't know this for sure because I haven't gotten this far yet.

Here is the code showing how I am using the variants above to conditional format them (the goal is to turn the active cell green and bold (with white letters) when the cells values are within .5).

Please Login or Register  to view this content.

Thank you all.

I'm not sure if the problem was unclear or not, This is the line in which the error occurs. Obviously the error would apply to each line that is near identical to this one:

Please Login or Register  to view this content.

The error states: Run-time error '1004':
Application-defined or object-defined error

The error definition in VBA is Identifier under cursor is not recognized.

I split this thread to contain only one question at a time.
The thread located here addresses the variable issue: http://www.excelforum.com/excel-prog...of-a-cell.html
This thread has been solved.

The second question resolved itself when the first question was solved.
Thanks to JOHN H. DAVIS: http://www.excelforum.com/members/john-h-davis.html