Select the range of cells.

FormatConditional FormattingFormula is:

=A120

If Excel changes A1 to $A$1 edit back to simply A1

Format to Bold and Italic and OK your way out.


Gord Dibben MS Excel MVP


On Wed, 13 Aug 2008 20:53:01 -0700, sg wrote:

-38 17 -2
-12 24 32
-10 36 9
46 -12 -23
-8 -25 -26
-32 -9 -39
3 -25 26
14 -36 -41
-46 -25 -48
42 -45 -3
-20 14 2 1/4

Bold and italicize all numbers greater than 20.
-30 -10 2