Max with Conditional Formatting in Office 2007
 

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

Max with Conditional Formatting in Office 2007
 

Bit of update. I was able to do this for row 7 and then copied formatting to
all other rows. It added three more rules that were similar, just referred
to different set of rows. I removed two of them and modifided one of them to
cover all of 7 to 73 and stayed applicable. 99% sure that is what I did
first time when highlighting all cells and did not work. I hope I do not
need to go through a couple steps to get it to work correctly. I used Format
only cells that contain and cell value equal to =max(t7:v73). it really
likes to add $ signs. Still let me know if better way to bold MAX.
--
Peter


"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

Max with Conditional Formatting in Office 2007
 

I must be missing something!

Nope. Although the number of options is greatly expanded, the new CF user
interface is pretty poorly designed.

Try this:

Delete any CF you currently have setup for this range.

Start over:

Select the *entire* range T7:V73 starting from cell T7. Cell T7 will be the
active cell.

Goto Home tabStylesConditional FormattingManage rulesNew ruleUse a
formula to determine which cells to format
Enter this formula in the box below:
=AND(T7<"",T7=MAX($T7:$V7))
Click the Format button
Select the desired style(s)
OK out


--
Biff
Microsoft Excel MVP


"peter" wrote in message
...
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

Max with Conditional Formatting in Office 2007
 

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

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