Change cell colour - IF statement

November 11, 2011 at 21:09:44
Specs: Windows 7
Hi all,

I'm aware of conditional formatting, but my issue can't be solved with it.

Say I have MAX(x, y) in a long series in Excel. I want to make it that if MAX chooses x, then the cell changes color.

Any help is greatly appreciated.

See More: Change cell colour - IF statement

Report •

November 12, 2011 at 10:45:55
Something like:


Conditional Formatting requires only a TRUE result to work.

But I get the feeling that this is not exactly what your looking for.


Report •

November 12, 2011 at 19:22:01
I think I'm as confused as Mike.

What do you mean by MAX(x,y) in a long series of numbers?

Perhaps an example of some actual data might help.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

Related Solutions

Ask Question