Highlight Cell Based On Other Cells

Microsoft Excel 2003 (full product)
October 27, 2010 at 18:17:04
Specs: Windows XP
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

See More: Highlight Cell Based On Other Cells

Report •


#1
October 28, 2010 at 08:25:21
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 OK

If 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 OK

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question