How to write the condition in SSRS for dynamically changing color of the cell based on value

Question

How to write the condition in SSRS for dynamically changing color of the cell based on value

https://i.sstatic.net/2XHL4.png

Answer 1

try something like this:

=IIf((Fields!nbday.Value >= 0 and Fields!nbday.Value < 90) ,"#3174c3",IIf((Fields!nbday.Value >= 90 and Fields!nbday.Value < 120),"#02C1D3","No Color"))