Formulas return values, not formatting.

See help on Conditional Formatting.


Gord Dibben MS Excel MVP

On Thu, 18 Jun 2009 11:59:01 -0700, Bob Arnett
wrote:

I would like it to display the results of a cell formula in the same format
that is in the referenced cell.
For instance (simplified):
Cell A1 is formatted in Bold and Red.
Cell A2 is formatted in Italics and Blue.
The formula in B1 is =Max(a1:a2)
Then B1 would display in Bold and Red if A1 was the higher of the two
numbers but in Italics and Blue if A2 was the higher.
Is there a way to do this?