I have the following colorization formula for a report in reference to a text field: "IE Version".
If ([IE Version]<9, "#FFCC99")
I imported a spreadsheet to create this field and most of the values were extended versioning numbers, e.g.,
but the formula still worked (compared the number to 9 and colorized if less than)
Now when I'm manually typing in a simple number like "11" this row is still being colorized, but I'm not sure why.