View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peter Peter is offline
external usenet poster
 
Posts: 349
Default Max with Conditional Formatting in Office 2007

Thanks to both of you and they helped. Also good to hear I am not the only
one confused!
--
Peter


"Ken" wrote:


Like so much other stuff in Excel 2007 this seemed to be harder and
more confusing than in 2003; but, I was eventually able to do it.
Highlight the cells you want to format; click "conditional formatting"
then "new rule"; then select the bottom choice of the top section "Use
a formula to tetermine...". Then enter your rule, like in 2003, and
your format of course. With my data in A1:C10, I used =A1=max
($a1:$c1); and it worked fine.

Good luck.

Ken





On Jun 26, 1:32 pm, peter wrote:
Maybe first question is where can I find a manual that will provide detailed
"How To's..." for the new conditional formatting in Office 2007? I have used
Excel for many years and conditionally formatting now rarely seems to do what
I want without a lot of steps. I must be missing something!

For now I also would like some specifc help. In cells T7:V73, I have price
information. For each row, I want to just bold the one of the three that is
MAX. Tried a few steps and either bolds just max for whole section or once
got it to bold everything. In the end, for each row amongst T to V there
will be one cell bolded. I think it should be simple, but just not having
any success.

Thanks in advance for all of the help!
--
Peter