How to change number format base on certain conditions

Hi,
Pls help. I have ~40 non-continuous range of cells and I need the number format to be changed base on certain conditions. Anyway, I don't think XL 2000 conditional formating can change the number format. (it should for font,border,pattern only).
Any method besides use VBA to change those region's (random location) number format one by one? Thanks in advance.

Fr, CS

Originally Posted by Bryan Hessey

Hi,

Apart from CTRL/select to select the range to manually set, if the cells are the result of formula you can, to some extent, adjust the formula to modify it's own format.

hth
---

Hi Byran,
Thank you very much.
Process to change number format for non-continous cell is repeated quick offen and the file is viewed by other users. If do it manually, them either complain or ignore to do it.
For using formula, that is a good idea. But at this moment I can only think about TEXT & FIXED to change number format. But both function convert the cell number to text and also remove the decimal behind it. Although I don't want to display full number, but I still need the full decimal for certain reason.
Is that other XL 2000 function which set number format just in display only ?
Regards.

Fr, CS

leecs,

Bryan is right, we have no idea what conditions would constitute the change in formatting. If you are using TEXT formula to change the format on numbers you can always multiply your formula by 1 to return it in the form of a usable number. You may also be able to use custom formatting for which you can set up to 6 conditions based on a number's value i.e. >=, <=, =, > or <. In the Format>Cells>Custom Format option something like:

[<2]0%;[>2]0.0;g

This formats the number as a % if it is less than 2 and as a number to one decimal place if greater than 2 and general if neither condition applies. Both retain a number as opposed to text. Again, more information would be helpful.

Steve

Hi,
Sorry for not proper explain in initial E-mail.
Btw, your previous suggestion (using condition number format) have give me a clue how to solve it. Now I am working on it & it solve my problem. Thank you very much.
Anyway, just for better knowledge, how to setup 6 conditions based on a number's value?
Regard.

Fr, CS Lee