I want the cell to format "0.00%" if the value is less than 100 and format
"$0" if the value is greater than 100. Conditional format won't format
numbers.

Thanks
-- bowada