Thanks, sounds like a possible solution. I'll let it know once i make some progress!
On 18 feb, 16:08, sallushan <[email protected]> wrote: > 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 -- Tekst uit oorspronkelijk bericht niet weergeven - > > - Tekst uit oorspronkelijk bericht weergeven -
