Numerical Conditional Formatting for Datatable doesn't work properly

One “hack” I came up with is to create a second column with the value of the first column multiplied by 100, and then filter on that column, but apply the conditional formatting to the first column.

Also, this hack will work on columns which have formatted numbers (with dollar signs, commas, percent signs, etc.). You could have a doppelgänger column which you filter on and then apply the conditional formatting to the formatted number column.