VB Macro, FOR loop with conditional formatting

I have a complex sheet where rows are continuosly overwritten and new data needs to be formatted each time. My macro works great aside from the fact the conditional format formula expression adds double quotes rendering the conditional format useless. After running the macro I can go into the conditional format field, remove the quotes, and the formatting formula works as expected. So...I first did a "record macro" to grab the code for conditional formatting:

Please Login or Register  to view this content.

Note: $BK$1, $BK$2, & $BK$3 contain the reference text for the conditional format. At any time before or after the macro is run a person must be able to edit "BK14" and change the format accordingly. (Please don't question the logic of the reference text list, I am automating certain tasks in a beast of a workbook and the list plays a significant role)

Here is my code to implement it in a FOR loop (shortened to one condition)...row number "14" in above is the variable:

Please Login or Register  to view this content.

So the formula is entered correctly into the conditional format area except a set or double quotes are put around the formula....removing quotes from the above code results in an incorrect formula, or a VB syntax error.

I'm so darn close I just can't get rid of those quotes...help?

Hi RM, welcome to the forum. Be sure to read through the Forum Rules so you can use and follow them effectively. For instance, you'll need to edit that post above, click Go Advanced and put code tags around that code you used.