I was curious if it is possible to give a single cell multiple number formats based on what the number is in the cell.
So for example if my number is bigger than 1000, I would like to use comas so that it looks like this 1,000. However, if it is less than 1000 I would like it to look more like this 999.00.
Is this possible?
P.S.: Would prefer to stay away from VBA (at least in this case)