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 |
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 ??? |
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 ??? |
All times are GMT +1. The time now is 03:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com