| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MAX in conditional formatting
Hello NG,
I'm trying to highlight (bold) a name in column A if the number in Column I is the MAX. I have 25 sales person listed in A3:A28 and several columns of numbers that total in column I. I've been trying to use the conditional formatting to make the name bold if the sale person has the highest sales figures for the week. I've tried in the conditional formatting window, if formula is =IF(I3 = (MAX(I3:I28)) then A3 should be bold Any help please ??? Thanks James |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
MAX in conditional formatting
Try
Formula is =I3=MAX($I$3:$I$28) In article , "James" wrote: I'm trying to highlight (bold) a name in column A if the number in Column I is the MAX. I have 25 sales person listed in A3:A28 and several columns of numbers that total in column I. I've been trying to use the conditional formatting to make the name bold if the sale person has the highest sales figures for the week. I've tried in the conditional formatting window, if formula is =IF(I3 = (MAX(I3:I28)) then A3 should be bold Any help please ??? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
MAX in conditional formatting
JE,
Thanks, it worked great James "JE McGimpsey" wrote in message ... Try Formula is =I3=MAX($I$3:$I$28) In article , "James" wrote: I'm trying to highlight (bold) a name in column A if the number in Column I is the MAX. I have 25 sales person listed in A3:A28 and several columns of numbers that total in column I. I've been trying to use the conditional formatting to make the name bold if the sale person has the highest sales figures for the week. I've tried in the conditional formatting window, if formula is =IF(I3 = (MAX(I3:I28)) then A3 should be bold Any help please ??? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I convert conditional formatting into explicit formatting? | Excel Discussion (Misc queries) | |||
| Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
![James[_38_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
