The conditional formatting in Excel doesn't seem to allow for numeric
formatting. I need to control the formatting of numeric cells as shown below-
Please help.

0.00# = 4 decimals
0.0# = 3 decimals
0.## = 2 decimals
1 to 9.99 = 2 decimals
10 to 99.9 = 1 decimal
100 plus = no decimals
--
TB