Conditional Formatting

D

David French

I have a range of cells that I want to use conditional formatting on.
I want the largest number in the range to be formatted or Highlighted or
something like that.
The conditions listed really don't seem to apply since the number may be
different each time so I can't say for certain that the number WILL BE
....whatever.
I just want to highlight the biggest number as compared to the rest in the
range.

Maybe i need to use a couple of different functions.

Please let me know.

Dave French

Office XP Pro
 
D

Dave Peterson

Select your range (say A1:C22)
With A1 the activecell
format|conditional formatting

Cell Value is:
Equal to
=MAX($A$1:$C$22)

Adjust the range to match and give it a pretty format.
 
D

Domenic

Assuming that A1:A10 contains your data, try...

1) Select/highlight A1

2) Format > Conditional Formatting > Formula Is

3) Enter the following formula:

=(A1<>"")*(A1=MAX($A$1:$A$10))

4) Choose your formatting

5) Click Ok and copy the format to other cells

Hope this helps!
 
Top