Count of cells in a row with specific background color

[#1]

Hi All,

I have created a table with color by expression. I need to create a column where I can show the count of cells which have red color.

Regards,
Vinayak

[niclaz79]

Hi, you need to reuse the same expression used to determine the color.

For instance, if your color expression was; if(Value > 1000, RGB(123,123,123), Black())

Your count would be Count(if(Value > 1000, WhatToCount)).

And add Distinct as needed.

[#3]

HI Niclas,

Thanks alot for such a prompt response.
But I have multiple expression for the each cell hence please help me in figuring this out how to use this.

Regards,

Vinayak