Microsoft Excel 2003 (full product)

In column e I have a range of number , in column a I have names . What I want to do is highlight in bold the name in column a based on the max nuber in column E . What am IU missing as this shouldn't be hard

I believe what your looking for is CONDITIONAL FORMATTING Without knowing what version of Excel your using, or how your data is set up,

the formula would be something like:=IF(MAX($E$3:$E$6)=E3,TRUE,FALSE)

If your using 2000 or 2003:

1) Select the range of cells you want highlighted, Column A in your case, (I've selected 100 cells, but you may modify that if you wish):

On the Menu Bar:

2) Format

3) Conditional Formatting

4) Change “Cell Value is” to “Formula Is”

5) Enter the formula:=IF(MAX($E$1:$E$100)=E1,TRUE,FALSE)

Sub Menu Format :

6) Patterns

7) Choose Pretty Color

8) Press OKIf your using 2007:

1) Select the range of cells you want highlighted, Column A in your case, (I've selected 100 cells, but you may modify that if you wish):

2) On the ribbon click Conditional Formatting

3) Click on New Rules, it’s near the bottom of the dialog box.

4) Click Use Formula to determine which cells to format.

5) Enter the formula:=IF(MAX($E$1:$E$100)=E1,TRUE,FALSE)

6) Click on the Format button

7) Select the Fill Tab

8) Select a pretty color

9) Click OK

10) Click OKMIKE

Ask Your Question

Weekly Poll