replace a range of numbers with specific formatting

[sg]

-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

 

[David Biddulph]

Have you tried conditional formatting?

 

[sg]

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

 

[Gord Dibben]

Select the range of cells.

Format>Conditional Formatting>Formula is:

=A1>20

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

 

[David Biddulph]

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