software

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][lt;30]General;[Red]\[General\]
Pascale wrote:
gt;
gt; hello
gt; I was asked to apply some formatting to a column so that if a number is
gt; superior to 30, it should appear in brackets in red and if it is inferior to
gt; 30 it should appear blue.
gt; I initially applied a conditional formatting until I saw that the numbers
gt; superior to 30 were supposed to have brackets around.
gt; Any suggestion anyone? I work with Excel 2002.
gt; 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 quot;generalquot; could be use for numbers.
Anyway, again THANK YOU
Pascale

quot;Dave Petersonquot; wrote:

gt; Maybe just a custom format:
gt; format|cells|custom category:
gt;
gt; [Blue][lt;30]General;[Red]\[General\]
gt;
gt;
gt;
gt; Pascale wrote:
gt; gt;
gt; gt; hello
gt; gt; I was asked to apply some formatting to a column so that if a number is
gt; gt; superior to 30, it should appear in brackets in red and if it is inferior to
gt; gt; 30 it should appear blue.
gt; gt; I initially applied a conditional formatting until I saw that the numbers
gt; gt; superior to 30 were supposed to have brackets around.
gt; gt; Any suggestion anyone? I work with Excel 2002.
gt; gt; Many thanks in advance
gt;
gt; --
gt;
gt; Dave Peterson
gt;