Conditional formating

[tampafreak69]

Is it possible to have a cell reference another cell and use conditional formating to change the number format. As follows

if the number is odd, then change the number format to currency

if the number is even, then change the number formart to just number with 2 decimals.

todd

[abubaniyan]

i dont think it is right to use the conditional formatting for the same but you can use this formula....than the results will be displayed in the next cell...and lastly conditional formatting is for highlighting the cells...
=IF(ISEVEN(a1),TEXT(a1,"$000000000000"),TEXT(a1,"0.00"))