Max with Conditional Formatting in Office 2007

  • Thread starter Thread starter peter
  • Start date Start date
P

peter

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!
 
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.
 
I must be missing something!
Click to expand...

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 tab>Styles>Conditional Formatting>Manage rules>New rule>Use 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
 
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
 
Back
Top