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

Question

https://i.stack.imgur.com/2XHL4.png

This existing answer might help you: [change color depending on value SSRS](https://stackoverflow.com/questions/34724228/change-color-depending-on-value-ssrs) — Niranjan Rajawat, Nov 07 '17 at 08:57

score 2 · Answer 1 · answered Nov 07 '17 at 09:13

Choose the Cell / Row / Column that you want to Change the color dynamically
Go to Properties (Hit F4)
Select Back Ground Color and Choose Expression
In the provided window, Give your Expression based on which the color will change.

Refer This Link for more details

score 2 · Accepted Answer · answered Nov 07 '17 at 14:57

2

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"))

answered Nov 07 '17 at 14:57

Mohamed Azizi

144
1
4
14

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

2 Answers2