Sorry for double posts, that was due to our brilliant ISP :)
On Feb 18, 8:07 pm, sallushan <[email protected]> wrote: > How about creating a nested "iif" > > e.g, > IIF( v = 1, "Red", IIF( v = 2, "Green", "Blue")) > > On Feb 18, 5:36 pm, Robin <[email protected]> wrote: > > > > > Hey, > > > I'm currently creating a report for Microsoft Project Server in Visual > > Studio. > > Everything is going great so far, but i'm currently stuck at dynamic > > styles. > > > I would like a certain cell to have a color based on the value. > > I know this is possible with 2 different values, like this: > > > =iif(Fields!Profit.Value < 0, "Red", "Black") > > (http://msdn.microsoft.com/en-us/library/ms252080.aspx) > > > But what if i would also like an Orange for the value 1? I was > > thinking of something like a switch or elseif, but that's not working > > (im not very experienced in VB!) > > > Thanks!- Hide quoted text - > > - Show quoted text -
