Excel Format - Apply number format based on formula

  • Thread starter Thread starter BIGBAX
  • Start date Start date
B

BIGBAX

I need to apply a number format to a cell based on the result of
formula. Conditional formatting does not work as this only allows me t
define the font, borders, and pattern.

Example :

If my formula returns the answer "TRUE" then I want to display a valu
formatted 1,234.10 but if the answer is "FALSE" then I want to displa
a date formatted 10/03/04.

Any ideas would be gratefully received
 
Hi BigBax!

You could use something like:

=IF(A1=TRUE,TEXT(B1,"#,###.00"),TEXT(B1,"dd/mm/yy"))

But note that this return is text and not a number formatted as
required.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top