Changing the color of a cell based on a formula.

Zac · Mar 28th, 2002, 07:42 AM

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

wi_guy · Mar 28th, 2002, 07:56 AM

Could this work????? Just changing O8 to a conditional formula that changes to "MIN" or MAX", based on the value of O15???

=IF(O15=MIN(R15:AM15),"MIN","MAX")

If not, yell and I'll play some more

Zac · Mar 28th, 2002, 08:29 AM

Tried the following :

=IF(O15=Min(R15:AM15),"Min","Max")

It worked when the formula was Min, but
it didn't change to Max when the formula wasn't Min(.......). In this case it was Max(.....).

Any other suggestions.

Zac

wi_guy · Mar 28th, 2002, 08:33 AM

If the formula in cell O15 changes from Min to Max when you click your Macro button, then this should work and cell O8 will change from "Min" to "Max" as well....if not, there is a typo, or i don't quite understand what is in cell O15.

Zac · Mar 28th, 2002, 11:20 AM

O15 has a resulting Numerical value based
on what is pulled in by the Min and Max formula.

=IF(O15=MIN(R15:AM15),"MIN","MAX")

Again when I hit the button to change the reqmnt from Min to MAX.
Min shows up in O8. Always.

I'm baffled.. I know it should work too, but it doesn't.

HELP.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 28th, 2002, 07:42 AM	#1
Zac Board Regular Join Date: Feb 2002 Location: Mike Posts: 796	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

Mar 28th, 2002, 07:56 AM	#2
wi_guy Board Regular Join Date: Mar 2002 Posts: 50	Could this work????? Just changing O8 to a conditional formula that changes to "MIN" or MAX", based on the value of O15??? =IF(O15=MIN(R15:AM15),"MIN","MAX") If not, yell and I'll play some more

Mar 28th, 2002, 08:29 AM	#3
Zac Board Regular Join Date: Feb 2002 Location: Mike Posts: 796	Tried the following : =IF(O15=Min(R15:AM15),"Min","Max") It worked when the formula was Min, but it didn't change to Max when the formula wasn't Min(.......). In this case it was Max(.....). Any other suggestions. Zac

Mar 28th, 2002, 08:33 AM	#4
wi_guy Board Regular Join Date: Mar 2002 Posts: 50	If the formula in cell O15 changes from Min to Max when you click your Macro button, then this should work and cell O8 will change from "Min" to "Max" as well....if not, there is a typo, or i don't quite understand what is in cell O15.

Mar 28th, 2002, 11:20 AM	#5
Zac Board Regular Join Date: Feb 2002 Location: Mike Posts: 796	O15 has a resulting Numerical value based on what is pulled in by the Min and Max formula. =IF(O15=MIN(R15:AM15),"MIN","MAX") Again when I hit the button to change the reqmnt from Min to MAX. Min shows up in O8. Always. I'm baffled.. I know it should work too, but it doesn't. HELP.