formatting numbers

P

Pascale

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
 
D

Dave Peterson

Maybe just a custom format:
format|cells|custom category:

[Blue][<30]General;[Red]\[General\]
 
P

Pascale

Dave
a big THANK YOU. It worked.
I would never have thought that not only you could insert a condition to a
custom format but also that "general" could be use for numbers.
Anyway, again THANK YOU
Pascale

Dave Peterson said:
Maybe just a custom format:
format|cells|custom category:

[Blue][<30]General;[Red]\[General\]


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
Click to expand...
Click to expand...
 
Top