In O15 I will have either of the following:
=Max(R15:AM15)
=Min(R15:AM15)
I have a button with a Macro attached that
let's us change from Max to MIN.
In Cell O8 I would like to have "MIN"
In Cell O9 I would like to have "MAX"
Is there a way to highlite either O8 or O9
with a colored background or Text alerting the user which formula is activated?
Maybe by using the Left (Fx) to view the 4
LEFT characters of O15 or something like that.
Any other ideas would be acceptable also.
As always Thanks for U R help,
Mike
=Max(R15:AM15)
=Min(R15:AM15)
I have a button with a Macro attached that
let's us change from Max to MIN.
In Cell O8 I would like to have "MIN"
In Cell O9 I would like to have "MAX"
Is there a way to highlite either O8 or O9
with a colored background or Text alerting the user which formula is activated?
Maybe by using the Left (Fx) to view the 4
LEFT characters of O15 or something like that.
Any other ideas would be acceptable also.
As always Thanks for U R help,
Mike