I know with conditional formatting you can change colours and fonts, but is there a way of changing the number of figures after the decimal point. For example, if my number is less than 100 I want two significant figures. If it is greater than 100 but less than 1000 I want one, and for greater than 1000 I don't want anything after the decimal point:
eg 99.99
999.9
9999
Thanks,
Penfold
eg 99.99
999.9
9999
Thanks,
Penfold