3 colours - conditional styles

[cognosun]

Hi,

We need to display..

values  '>0' in red.
values '<0' in green.
values '=0' in black.

I've achieved first 2 formats using conditional styles, is there anyway to achieve 3rd format using conditional style.

Many thanks,
Joys

[pricter]

Instead of using conditional styles you could a style variable. Is this acceptable for you?
For example create a string variable with the following expression
case
when [Query1].[Unit cost]<0
then 'R'
when [Query1].[Unit cost]>0
then 'G'
else
'B'
end
and then and three values R, G, B

Declare the variable as a style variable and define your preffered colour for its variable value.

[cognosun]

Yeah..I was looking using conditional styles :-)

[blom0344]

Pricter's solution is more versatile and works equally well..  Why not try it?