Multiple Conditions for Conditional Background Fill of Cells

amaiaita — Wed, 14 Dec 2022 14:45:40 GMT

I am trying to get a column in my table to have a condition that if the value in it is the string "+ve" then the background is blue, and if the string is the word "-ve" then it is filled with Silver. This works when putting in only one condition as:

=((IIF(Fields!ID2017.Value="-ve","Silver","No Color"))

However, when attempting to put the second condition in as follows I either get an error or only the first condition works:

=((IIF(Fields!ID2017.Value="-ve","Silver","No Color")) Or (IIF(Fields!ID2017.Value="+ve","Blue","No Color")))

I have also tried:

=((IIF(Fields!ID2017.Value="-ve","Silver","No Color")) And (IIF(Fields!ID2017.Value="+ve","Blue","No Color")))

would really appreciate if someone was able to help!

Re: Multiple Conditions for Conditional Background Fill of Cells

d_gosbell — Wed, 14 Dec 2022 23:24:58 GMT

So you would achieve this by nesting your IIF functions

=IIF(Fields!ID2017.Value="-ve","Silver", IIF(Fields!ID2017.Value="+ve","Blue","No Color") )

Re: Multiple Conditions for Conditional Background Fill of Cells

amaiaita — Thu, 15 Dec 2022 08:45:18 GMT

That worked, thanks so much!

topic Re: Multiple Conditions for Conditional Background Fill of Cells in Report Server

Multiple Conditions for Conditional Background Fill of Cells

Re: Multiple Conditions for Conditional Background Fill of Cells

Re: Multiple Conditions for Conditional Background Fill of Cells