Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Mac > Excel Office for Mac > conditional for...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 3 Topic 5617 of 5882
Post > Topic >>

conditional format

by Harvey Waxman <hnwaxman@[EMAIL PROTECTED] > May 14, 2008 at 06:36 PM

row containing several numerical values

I'd like to conditionally format the row such that the maximum value is 
automatically formatted.

"formula is"    "=max(1B:1P)"

then choose a format.

It doesn't work.  All the values in the row show the same format, not 
the maximum value alone.

Can I do this without an auxiliary cell containing the maximum value?

Thanks

Excel X  in Leopard
 




 3 Posts in Topic:
conditional format
Harvey Waxman <hnwaxma  2008-05-14 18:36:36 
Re: conditional format
Bob Greenblatt <bob@[E  2008-05-15 07:39:19 
Re: conditional format
Harvey Waxman <hnwaxma  2008-05-15 08:11:26 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Wed Jul 9 9:06:45 CDT 2008.