View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pascale
 
Posts: n/a
Default formatting numbers

hello
I was asked to apply some formatting to a column so that if a number is
superior to 30, it should appear in brackets in red and if it is inferior to
30 it should appear blue.
I initially applied a conditional formatting until I saw that the numbers
superior to 30 were supposed to have brackets around.
Any suggestion anyone? I work with Excel 2002.
Many thanks in advance