Formula with Cell reference to include formating?
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?
|