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