Different color for each function, within a single cell?

[gatsby692]

Hi all

I have a cell that shows the maximum and minimum values of a range, within a single cell, like this:

Please Login or Register  to view this content.

What I want to do is display the max value in green, and the minimum value in red.

Is this possible? I'm using Excel 2000.

[Andy Pope]

You can not have multiple formatting in a cell that contains a formula.
You would need to use multiple cells.