View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default 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