Not sure how to do that. I thought you could only do conditional formatting
under the conditional formatting tab. Where would he put the condition under
the default format for the cell? I don't see any way to do that, at least not
in my Excel 2003.
--
future_vba_expert


"Gary''s Student" wrote:

There are only two cases, perhaps the default format could cover one of them?
--
Gary''s Student - gsnu200857


"future_vba_expert" wrote:

I think you would have to enter 2 formulas, with the 2 different formats, one
for A1 A2, and one for A2 A1. Don't see how 1 formula with MAX can do
this, but please enlighten me if it is possible. Thanks.
--
future_vba_expert


"Gary''s Student" wrote:

Format Conditional formatting... FormulaIs =A1=MAX(A1:A2) and pick the
format, etc.
--
Gary''s Student - gsnu200857


"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?