replace a range of numbers with specific formatting
 

-38 17 -29
-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

--
Sarah

replace a range of numbers with specific formatting
 

Have you tried conditional formatting?
--
David Biddulph

"sg" wrote in message
...
-38 17 -29
-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

--
Sarah

replace a range of numbers with specific formatting
 

no i have not, not sure i know what to do
--
Sarah


"David Biddulph" wrote:

Have you tried conditional formatting?
--
David Biddulph

"sg" wrote in message
...
-38 17 -29
-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

--
Sarah

replace a range of numbers with specific formatting
 

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

replace a range of numbers with specific formatting
 

As a start, try typing "conditional formatting" into Excel help.
--
David Biddulph

"sg" wrote in message
...
no i have not, not sure i know what to do
--
Sarah


"David Biddulph" wrote:

Have you tried conditional formatting?
--
David Biddulph

"sg" wrote in message
...
-38 17 -29
-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

--
Sarah