Thank you for your response.

Yes I conditionally setting the cells background color using swich. Since there are more than 70 columns, each column has complicated condition to get background color, I would like use the color result to update this column value.

Another question is hidding property.

I tried to hide a row as long as any columns in this row has background color = "yellow". It doesn't work if using statement as

IIF(fields!col1.backgroundcolor = "Yellow", true, false).

Can you help?

Thanks again.