Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Office 2007 Conditional Formatting question | Excel Discussion (Misc queries) | |||
condtional formatting in office 2007 is not working properly | Excel Discussion (Misc queries) | |||
Conditional Formating - by row, not by column (Office 2007) | Excel Discussion (Misc queries) | |||
Conditional Formating Using Office 2007 | Excel Worksheet Functions | |||
Conditional formatting 2007 | Excel Worksheet Functions |