Hi All,

Is there any way to conditionally control the number of decimal places displayed by a cell based on its value? More specifically, i want zero decimal places if the value is greater than 100; 2 decimal places for values less than 100.

Decimal places doesn't appear to be configurable using the standard conditional formatting, and I’ve had no joy experimenting with the "if" function.

Any comments/help appreciated.

Thanks
The Grinch