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

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

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



Pascale wrote:

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

--

Dave Peterson

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" wrote:

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

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



Pascale wrote:

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

--

Dave Peterson