Conditional formating of numbers saved as text

Background of problem:

Data the I receive is in the form of numbers stored as text. (Must keep significant figures)
I track this with a formula to return the significant digits..

The final form of the data should be stored as numbers as text. Currently using Fixed() function recalling the significant digits from the beginning.

Problem:
Ok my dilemma, the final thing I need to do is conditional formatting of the data using numbers.

Example of single data entry
Step 1

'324.24 - Received from import

Step 2

Determine digits beyond decimal point =2

Step 3

Use Value() to turn into number.
324.24000

Step 4

Apply Conditional format. (if < 350 and > 300 then green text and Underline)

Step 5

Reapply Significant Digits from Step 2 using Fixed(324.240000,2)
324.24

The issue is once I change the cell back to text the conditional formatting fails.

Thank you in advance.