Conditional Formating converting recorded macro to use variable issue

Hi I have recorded a macro to use as a basis to create some Conditional Formatting, however, I am not able to correctly rewrite it with variables for some reason.

When I look at the resultant of my edited macro, it basically changes it from a Cell Value statement to a Formula statement when I look at "Manage Rules" and gives me a TRUE result for all cells

Here is the recorded macro line:

Please Login or Register  to view this content.

This was my attempt to use variables:

Please Login or Register  to view this content.

Unfortunately, when reviewing the original conditional format manually input, it says correctly:
Cell Value < $K11*$G$3 Applies to =$E$11:$J$38

While the macro replacement is
Formula =TRUE and applies to =$E$11:$J$38

I am sure this is just a syntax issue, but what is the issue?

Probably:

Please Login or Register  to view this content.

Artik

Originally Posted by Artik

Probably:

Please Login or Register  to view this content.

Artik

NO,

I had tried that earlier, by replacing all of the variants from False to True 1 at a time, then all of them.
Finally switched only the first variants to TRUE, and while it gets me closer in the conditions "Manage Rules", it still does NOT highlight anything.

the original conditional format manually input, it says and works correctly:
CEll Value <$K11*$g$3 Applies to =$E$11:$J$38

What I see now after changing TRUE variants is:
Formula: ="<$K11*(0.1)" Applies to =$E$11:$J$38

Note differences above... I am not too worried about the value (0.1) as that is the cell value in cell $g$3
But what changes this from Cell Value to Formula: ="

This Thread was created incorrectly so I have stated solved rather than deleting. I don't se a delete?