Does Excel see a cell w/ formulas as non-empty cell?

When using a VBA UserForm to write data to the worksheet....How do you make excel ignore conditional formatting within the cells and see them as blank cells?

I was using the find last row code and when the useform writes the data it sees any conditional formatting as non-blank cells and writes the data in the rows below.

How can I force it to write in the cells with conditional formatting in them?

I will have to post an example tomorrow when I get to work.