Thanks:  0
Likes:  0

# Thread: Changing the color of a cell based on a formula.

1. 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

2. 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

3. 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

4. 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.

5. 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.

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•