replace a range of numbers with specific formatting

  • Thread starter Thread starter sg
  • Start date Start date
S

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
 
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
 
Back
Top