April 18, 2018 at 12:38 am
How do I color code a cell value based on values.
My current condition for this cell is
iif((Fields!DBName.Value <> "tempdb" and Fields!State_desc.Value = "ONLINE")
AND IsNothing(Fields!Physical_device_name.Value),"Orange", "LightGreen")
In addition to the above conditions I also want to check if the below field,LastDateValue has value greater than 24hrs then I have to color code the entire row as RED else it is LightGreen
Ex:Current value in Cell LastDateValue:2018-04-17 01:01:18.000
Thanks
April 24, 2018 at 11:07 pm
Joe Torre - Wednesday, April 18, 2018 12:17 PMPlease have a look here.
You my need to nest you IIF
Iif(Fields!DBName.Value <> "tempdb",
Iif(Fields!State_desc.Value = "ONLINE", IsNothing(Fields!Physical_device_name.Value),"Orange"
, "LightGreen"),
"LightGreen"),
"LightGreen")
HTH
Thank you but the code is not working
April 25, 2018 at 10:02 am
mtz676 - Tuesday, April 24, 2018 11:07 PMJoe Torre - Wednesday, April 18, 2018 12:17 PMPlease have a look here.
You my need to nest you IIF
Iif(Fields!DBName.Value <> "tempdb",
Iif(Fields!State_desc.Value = "ONLINE", IsNothing(Fields!Physical_device_name.Value),"Orange"
, "LightGreen"),
"LightGreen"),
"LightGreen")
HTHThank you but the code is not working
What do you mean "not working"? Can you be more descriptive please?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply