Forum Discussion

amaiaita's avatar
amaiaita
Regular Visitor
3 years ago
Solved

Multiple Conditions for Conditional Background Fill of Cells

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....
Conditional Formatting
Conditional Formatting column
  • d_gosbell's avatar
    d_gosbell
    3 years ago

    So you would achieve this by nesting your IIF functions

     

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

     

     

d_gosbell's avatar
d_gosbell
Super User
3 years ago

So you would achieve this by nesting your IIF functions

 

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

 

 

  • amaiaita's avatar
    amaiaita
    Regular Visitor
    3 years ago

    That worked, thanks so much!