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
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.
Yeah..I was looking using conditional styles :-)
Pricter's solution is more versatile and works equally well.. Why not try it?