Colour cell with biggest value

[axeld]

Hi!

How to make the biggest value in table change font color?

thanks in advance
adam

[NBVC]

Select range, go to Format|Condtional formatting

Select Formula Is from 1st drop down menu

Enter formula: =A1=MAX($A$1:$D$100)

(where A1 is top left most cell you selected and A1:D100 is the entire selected table.)

Click Format and choose from the Pattern Tab

[axeld]

Ok. thanks - it works perfect!
But I have one more question:

What if I want to color 3 biggest values? is it possible?

for example: 1 2 3 4 9 8 4 5 3 2 1
9, 8 an 5 have different color.

[NBVC]

Use formula instead:

=A1>=LARGE($A$1:$D$100,3)

[axeld]

works! but should be:

=A1>=LARGE($A$1:$D$100;3)

thanks!!!

[NBVC]

That is because you have a different version of excel that uses semicolons as argument separator.