You can do that with a VBA event proc.

HTH
--
AP

"Antonio" a écrit dans le message de
news: ...
I need to format a number in a cell depending on the contents of a
different
cell.

Some cells will have two decimals, some none, depending on the contents of
their adjacent cells.

Conditional formatting. Formula Is. Allows me to change the font, border,
pattern etc. but not the number format.

Is it possible to do ?

Thanks,


Antonio