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
|