is there any way to do conditional formatting with more than two options? for example, is there any way to take a statement such as this that returns 1 of 2 values:
=IIf(Fields!Cost.Value > Fields!Revenue.Value, "Red", "Black")
and create a statement that would return more than two?
thanks